aboutsummaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAge
* Got "ADD" to appear only in ALTER TABLE and not CREATE TABLEBruce Momjian2001-11-04
| | | | | UNIQUE-PRIMARY KEY notice message. This is what Christopher wanted from his patch.
* Remove "ADD" from TABLE / ADD UNIQUE-PRIMARY error message because theBruce Momjian2001-11-04
| | | | | same code is called for both creation and alter. Not worth worrying about.
* Add default expressions to INSERTs during planning, not during parseTom Lane2001-11-02
| | | | | | analysis. This keeps stored rules from prematurely absorbing default information, which is necessary for ALTER TABLE SET DEFAULT to work unsurprisingly with rules. See pgsql-bugs discussion 24-Oct-01.
* Fix pg_pwd caching mechanism, which was broken by changes to forkTom Lane2001-11-02
| | | | | | | postmaster children before client auth step. Postmaster now rereads pg_pwd on receipt of SIGHUP, the same way that pg_hba.conf is handled. No cycles need be expended to validate password cache validity during connection startup.
* Fix problem reported by Alex Korn: if a relation has been dropped andTom Lane2001-11-02
| | | | | | | | | | | | | | | | | | recreated since the start of our transaction, our first reference to it errored out because we'd try to reuse our old relcache entry for it. Do this by accepting SI inval messages just before relcache search in heap_openr, so that dead relcache entries will be flushed before we search. Also, break heap_open/openr into two pairs of routines, relation_open(r) and heap_open(r). The relation_open routines make no tests on relkind and so can be used to open anything that has a pg_class entry. The heap_open routines are wrappers that add a relkind test to preserve their established behavior. Use the relation_open routines in several places that had various kluge solutions for opening rels that might be either heap or index rels. Also, remove the old 'heap stats' code that's been superseded by Jan's stats collector, and clean up some inconsistencies in error reporting between the different types of ALTER TABLE.
* Minor code cleanups.Tom Lane2001-11-01
|
* Reject tabs and linefeeds in usernames and passwords that are beingTom Lane2001-11-01
| | | | | | stored in pg_pwd, to guard against failures of the sort observed by Tom Yackel. Note: in the case of encrypted passwords this is no restriction, since the string we are interested in is the MD5 hash.
* Add missing #include.Tom Lane2001-11-01
|
* Suppress trivial compiler warning.Tom Lane2001-11-01
|
* More *.po cleanups for new spacing.Bruce Momjian2001-10-31
|
* Modify *.po files and regression expected output for new clearer errorBruce Momjian2001-10-31
| | | | message spacing.
* Here is an updated version of /src/backend/po/ru.poBruce Momjian2001-10-31
| | | | | | | | which incorporates recent changes by Bruce to readability of some messages and few more translations. -- Serguei A. Mokhov
* Add ALTER TABLE ADD UNIQUE regression tests from Christopher Kings-Lynne.Bruce Momjian2001-10-31
| | | | | | Add space between slash for ALTER TABLE / ADD .... Regression and *.po updates to follow.
* Fix problems with subselects used in GROUP BY expressions, per gripeTom Lane2001-10-30
| | | | | | from Philip Warner. Side effect of change is that GROUP BY expressions will not be re-evaluated at multiple plan levels anymore, whereas this sometimes happened with old code.
* Fix small problem Tom Lane found with pgindent run.Bruce Momjian2001-10-30
|
* Add gp->gr_mem != NULL check for Solaris, per Seth HettichBruce Momjian2001-10-29
|
* Check for NULL return from getgrgid(), per Seth HettichBruce Momjian2001-10-29
|
* Another pgindent run. Fixes enum indenting, and improves #endifBruce Momjian2001-10-28
| | | | spacing. Also adds space for one-line comments.
* Fix a couple of places where lack of parenthesization of a castTom Lane2001-10-25
| | | | | causes pgindent to make weird formatting decisions. Easiest fix seems to be to put in the extra parens...
* Add int2-to-int8 and int8-to-int2 conversion routines. Needed to avoidTom Lane2001-10-25
| | | | | breaking existing pg_dump scripts, which try to assign the result of count(*) to an int2 variable. catversion bumped.
* Add missing output routine for FkConstraint nodes.Tom Lane2001-10-25
|
* pgindent run on all C files. Java run to follow. initdb/regressionBruce Momjian2001-10-25
| | | | tests pass.
* Add do { ... } while (0) to more bad macros.Bruce Momjian2001-10-25
|
* All three *.po patches applied.Bruce Momjian2001-10-24
| | | | forth@pagic.net
* Allow concurrent index creation for the same table.Hiroshi Inoue2001-10-24
|
* Add support for INTERVAL's new typmod values to format_type.Tom Lane2001-10-23
|
* Fix foreign keys on system columns.Tom Lane2001-10-23
|
* Make SPI's column-accessing functions work for system columns as well asTom Lane2001-10-23
| | | | user columns. Needed for foreign keys on OID, but useful in general.
* Now I had them reversed. Wow that syntax is error-prone.Bruce Momjian2001-10-23
|
* Syntax fix. Can't use #ifdef in gram.y.Bruce Momjian2001-10-23
|
* Back out LIMIT #,# removal and mark it as to-be-removed in 7.3.Bruce Momjian2001-10-23
|
* Add error checking to PageRepairFragmentation to ensure that it canTom Lane2001-10-23
| | | | | | never overwrite adjacent pages with copied data, even if page header and/or item pointers are already corrupt. Change inspired by trouble report from Alvaro Herrera.
* Cause transformIndexConstraints() to do the right thing with requestsTom Lane2001-10-22
| | | | for indexes on system columns. Per complaint from Peter.
* Consolidate tables of known system attributes into one table.Tom Lane2001-10-22
|
* Further cleanup of ps_status setup code. On platforms where theTom Lane2001-10-22
| | | | | | | | environment strings need to be moved around, do so when called from initial startup (main.c), not in init_ps_status. This eliminates the former risk of invalidating saved environment-string pointers, since no code has yet had a chance to grab any such pointers when main.c is running.
* Add defenses against invalid operator names passed in CREATE OPERATORTom Lane2001-10-22
| | | | | arguments (where the parser doesn't check them already). Minor code cleanups too.
* Fix FindExec() for case where executable is found via a relative pathTom Lane2001-10-21
| | | | in .:/home/postgres/testversion/bin:/opt/perl5.6.1/bin:/home/postgres/bin:/usr/local/bin:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/upgrade/bin:/opt/CC/bin:/opt/langtools/bin:/opt/graphics/phigs/bin:/opt/java/bin:/bin:/opt/imake/bin:/opt/hparray/bin:/opt/aCC/bin:/opt/lrom/bin:/usr/local/nmh/bin:. (I suppose the only common case for this is '.').
* Fix getopt-vs-init_ps_display problem by copying original argv[] info,Tom Lane2001-10-21
| | | | | | per suggestion from Peter. Simplify several APIs by transmitting the original argv location directly from main.c to ps_status.c, instead of passing it down through several levels of subroutines.
* Change LIMIT #,# error message to be more generic.Bruce Momjian2001-10-20
|
* Remove LIMIT #,# and suggest LIMIT # OFFSET #, per mailing list discussion.Bruce Momjian2001-10-20
|
* Fix transposed arguments for typmod for one INTERVAL production.Thomas G. Lockhart2001-10-20
| | | | | | | | | | | | | | Mask both typmod subfields for INTERVAL to avoid setting the high bit, per dire warning from Tom Lane. Clear tmask for DTK_ISO_TIME case to avoid time zone troubles. Symptom reported by Tom Lane. Clean up checking for valid time zone info in output routine. This should now work for both SQL99 and Unix-style time zones. Put in explicit check for INTERVAL() typmod rounding to avoid accumulating cruft in the lower bits. Not sure that this helps, but we'll need to do something. The symptom is visible with a query like select interval(2) '10000 days 01:02:03.040506'; Regression tests are patched to repair the Tom Lane symptom, and all pass.
* Proper fix for glibc getopt() botch. Surprising we did not see thisTom Lane2001-10-19
| | | | before.
* Set optreset on platforms that have it before launching postmasterTom Lane2001-10-19
| | | | | | subprocesses; perhaps this will fix portability problem just noted by Lockhart. Also, move test for bad permissions of DataDir to a more logical place.
* Ensure that all startup paths (postmaster, standalone postgres, orTom Lane2001-10-19
| | | | | | | bootstrap) check for a valid PG_VERSION file before looking at anything else in the data directory. This fixes confusing error report when trying to start current sources in a pre-7.1 data directory. Per trouble report from Rich Shepard 10/18/01.
* Move init_ps_display from postgres.c to postmaster.c, putting itTom Lane2001-10-19
| | | | | | | | | | | just after receipt of the startup packet. Now, postmaster children that are waiting for client authentication response will show as 'postgres: user database host authentication'. Also, do an init_ps_display for startup/shutdown/checkpoint subprocesses, so that they are readily identifiable as well. Fix an obscure race condition that could lead to Assert failure in the postmaster --- attempting to start a checkpoint process before any connections have been received led to calling PostmasterRandom before setting random_seed.
* Spell 'between' correctly, clean up spacing in error messages.Tom Lane2001-10-18
|
* Fix memory leakage when sending notice messages to client.Tom Lane2001-10-18
|
* Fix authentication so that it doesn't record an extra 'PasswordTom Lane2001-10-18
| | | | | | | | | | authentication failed' and a 'send() failed: Broken pipe' message on every connection from psql in password auth mode. Problem is that psql doesn't ask user for a password until it sees a password challenge failure, and libpq just closes the connection unceremoniously if it's challenged for a password when it hasn't got one to send. Accordingly, EOF from the client after asking for a password is normal behavior and should not result in postmaster log entries.
* Didn't compile on non-HAVE_TM_ZONE machines.Tom Lane2001-10-18
|
* Repair missing brace in HAVE_INT_TIMEZONE case.Tom Lane2001-10-18
|