summaryrefslogtreecommitdiff
path: root/src/backend/commands
Commit message (Collapse)AuthorAgeFilesLines
* Remove recipe.o from Makefile ... dead code not quite dead enough,Tom Lane1999-02-271-2/+2
| | | | it seems.
* Fix problem with selectivity error in added columns with ALTER TABLE.Bruce Momjian1999-02-245-6/+25
| | | | Move files to deadcode.
* From: Tatsuo Ishii <t-ishii@sra.co.jp>Marc G. Fournier1999-02-211-2/+2
| | | | | | Ok. I made patches replacing all of "#if FALSE" or "#if 0" to "#ifdef NOT_USED" for current. I have tested these patches in that the postgres binaries are identical.
* Enable bushy and right-hand queries by default.Bruce Momjian1999-02-181-55/+1
|
* Change my-function-name-- to my_function_name, and optimizer renames.Bruce Momjian1999-02-1319-60/+60
|
* Rename Temp to Noname for noname tables.Bruce Momjian1999-02-091-3/+3
|
* Added LIMIT/OFFSET functionality including new regression test for it.Jan Wieck1999-02-081-2/+20
| | | | | | | Removed CURRENT keyword for rule queries and changed rules regression accordingly. CURRENT has beed announced to disappear in v6.5. Jan
* Changed ExecConstraints() and ExecRelCheck() to cache the constraintsJan Wieck1999-02-071-2/+3
| | | | | | | | | qualification expression trees in the execution state. Prevents from memory exhaustion on INSERT, UPDATE or COPY to tables that have CHECK constraints. Speedup against the variant using freeObject() is more than factor 2. Jan
* Cleanup of source files where 'return' or 'var =' is alone on a line.Bruce Momjian1999-02-038-69/+38
|
* Optimizer rename ClauseInfo -> RestrictInfo. Update optimizer README.Bruce Momjian1999-02-031-1/+2
|
* Add TEMP tables/indexes. Add COPY pfree(). Other cleanups.Bruce Momjian1999-02-027-39/+26
|
* Fixed growing of backend due to not pfree()'d data on COPY FROMJan Wieck1999-02-012-2/+3
| | | | | | | Fixed growing of backend if BEFORE DELETE trigger returns heap tuple different from trigtuple. Jan
* Hope that execMain.c good merged.Vadim B. Mikheev1999-01-291-9/+20
| | | | | Fix for BEFORE ROW UPDATE triggers: result tuple may be different (due to concurrent update) from one initially produced by top level plan.
* READ COMMITTED isolevel is implemented and is default now.Vadim B. Mikheev1999-01-291-2/+21
|
* Add explicit buffering in backend libpq, to compensate forTom Lane1999-01-231-4/+2
| | | | buffering lost by not going through stdio anymore for client I/O.
* The following patch finishes primary key support. Previously, whenBruce Momjian1999-01-212-5/+7
| | | | | | | | | | | | | | | | | | | | a field was labelled as a primary key, the system automatically created a unique index on the field. This patch extends it so that the index has the indisprimary field set. You can pull a list of primary keys with the followiing select. SELECT pg_class.relname, pg_attribute.attname FROM pg_class, pg_attribute, pg_index WHERE pg_class.oid = pg_attribute.attrelid AND pg_class.oid = pg_index.indrelid AND pg_index.indkey[0] = pg_attribute.attnum AND pg_index.indisunique = 't'; There is nothing in this patch that modifies the template database to set the indisprimary attribute for system tables. Should they be changed or should we only be concerned with user tables? D'Arcy
* Apply Win32 patch from Horak Daniel.Bruce Momjian1999-01-173-3/+19
|
* From: Magnus Hagander <mha@sollentuna.net>Marc G. Fournier1999-01-111-51/+154
| | | | | | | | | | | | Here is a first patch to cleanup the backend side of libpq. This patch removes all external dependencies on the "Pfin" and "Pfout" that are declared in pqcomm.h. These variables are also changed to "static" to make sure. Almost all the change is in the handler of the "copy" command - most other areas of the backend already used the correct functions. This change will make the way for cleanup of the internal stuff there - now that all the functions accessing the file descriptors are confined to a single directory.
* Fixed nodeToString() to put out "<>" for NULL strings again.Jan Wieck1998-12-181-7/+7
| | | | | | More cleanups to appendStringInfo() usage in node/outfuncs.c. Jan
* SET TRANSACTION ISOLATION LEVEL ...Vadim B. Mikheev1998-12-183-4/+89
| | | | | LOCK TABLE IN ... MODE ...implemented
* Initial MVCC code.Vadim B. Mikheev1998-12-1512-142/+174
| | | | New code for locking buffer' context.
* more cleanups...of note, appendStringInfo now performs like sprintf(),Marc G. Fournier1998-12-143-18/+29
| | | | | | | | | | where you state a format and arguments. the old behavior required each appendStringInfo to have to have a sprintf() before it if any formatting was required. Also shortened several instances where there were multiple appendStringInfo() calls in a row, doing nothing more then adding one more word to the String, instead of doing them all in one call.
* Many more cleanups...Marc G. Fournier1998-12-143-102/+73
|
* Initial attempt to clean up the code...Marc G. Fournier1998-12-147-88/+75
| | | | | | Switch sprintf() to snprintf() Remove any/all #if 0 -or- #ifdef NOT_USED -or- #ifdef FALSE sections of code
* New HeapTuple structure/interface.Vadim B. Mikheev1998-11-2713-203/+171
|
* Fix using indices in OR.Vadim B. Mikheev1998-11-221-4/+9
| | | | EXPLAIN all indices used.
* EXPLAIN VERBOSE had a very high probability of triggeringTom Lane1998-11-081-20/+33
| | | | | | a backend core dump, because it was concatenating a potentially long string onto another string that didn't necessarily have enough room. Shame, shame.
* Get rid of some minor compiler warnings.Tom Lane1998-10-262-9/+10
| | | | | (HP's cc doesn't like if you forward-declare a routine static, and then don't make it static in the actual definition...)
* Fix from Jan for vacuum statistics loss.Bruce Momjian1998-10-231-4/+24
|
* Update for bsdi 3.0.Bruce Momjian1998-10-231-5/+4
|
* The patch does 2 things:Bruce Momjian1998-10-213-16/+50
| | | | | | | | | | | | Fixes a bug in the rule system that caused a crashing backend when a join-view with calculated column is used in subselect. Modifies EXPLAIN to explain rewritten queries instead of the plain SeqScan on a view. Rules can produce very deep MORE Jan.
* New QUERY_LIMIT set command.Bruce Momjian1998-10-141-7/+96
|
* Fix for vacuum and cache use. Fix for BSDI 4.0.Bruce Momjian1998-10-121-7/+4
|
* Reverse out vacuum change.Bruce Momjian1998-10-091-32/+1
|
* major/minor shared name cleanupBruce Momjian1998-10-091-1/+32
|
* Clean up minor gcc warning about lack of reset_r_plans prototype.Tom Lane1998-10-081-2/+2
|
* No need compile command/version.c anymore.Bruce Momjian1998-10-081-2/+2
|
* Make functions static or ifdef NOT_USED. Prevent pg_version creation.Bruce Momjian1998-10-081-17/+39
|
* Hello!Bruce Momjian1998-10-081-2/+1
| | | | | | | | | | | | | | | | | | | Here are two new patches for the Win32 support. 1) The patch based on the one from Hiroshi Inoue [Inoue@tpf.co.jp], to load Winsock.dll from libpq.dll. 2) A patch for psql.c to remove the call to WSAStartup(), since it is not required when it's done in libpq.dll. I'm still looking for the possibility of having a crypt() function in libpq.dll too, the same way getopt was included. Any chance of getting this before 6.4, or should we wait for the next one? //Magnus
* vacuum cleanupsBruce Momjian1998-10-071-29/+9
|
* Fix snprintf.c for machines that don't have long long, like some Irix.Bruce Momjian1998-10-071-3/+3
|
* Substantial rewrite of async.c to avoid problems with non-reentrant stdioTom Lane1998-10-061-473/+575
| | | | | and possibly other problems. Minor changes in xact.c and postgres.c's main loop to support new handling of async NOTIFY.
* Fix up warning and error messages to use single-quotes around strings.Thomas G. Lockhart1998-10-051-13/+13
|
* Fix for constbyval .Bruce Momjian1998-10-011-3/+2
|
* Allow 8-key indexes.Bruce Momjian1998-09-234-8/+8
|
* AIX align fix.Bruce Momjian1998-09-081-2/+2
|
* Alignment cleanup so no more massive switch statements for alignment,Bruce Momjian1998-09-071-33/+4
| | | | just two macros.
* [Part #1: Type: text/plain, Encoding: 7bit, Size: 59]Bruce Momjian1998-09-031-1/+49
| | | | | | I will be cleaning this up more before the Oct 1 deadline. David Hartwig. AND/OR fix.
* Fix for indexing problems.Bruce Momjian1998-09-021-2/+2
|
* OK, folks, here is the pgindent output.Bruce Momjian1998-09-0119-257/+259
|