aboutsummaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAge
* From: Dan McGuirk <mcguirk@indirect.com>Marc G. Fournier1997-03-12
| | | | | | | | Subject: [HACKERS] better access control error messages This patch replaces the 'no such class or insufficient privilege' with distinct error messages that tell you whether the table really doesn't exist or whether access was denied.
* From: Dan McGuirk <mcguirk@indirect.com>Marc G. Fournier1997-03-12
| | | | | | | Subject: [HACKERS] backend Makefile patch This patch cleans up backend/Makefile a little bit, and prevents it from relinking the backend binary when no changes have been made.
* From: Dan McGuirk <mcguirk@indirect.com>Marc G. Fournier1997-03-12
| | | | | | | | | Subject: [HACKERS] abort failed transaction patch This patch allows you to end a transaction that has failed on an error using the 'ABORT' statement without generating another error message. (By default you get an error unless you use 'END' to terminate the transaction, which has already been aborted anyway.)
* Add missing paren.Bruce Momjian1997-03-10
|
* Massimo's Deadlock patches w/o the #ifdefsMarc G. Fournier1997-03-10
|
* Vacuum cleanups from Massimo.Bruce Momjian1997-03-09
|
* Add prototypes for oracle-compat functions. Rename geo-*.c adt to geo_*.cBruce Momjian1997-03-09
|
* Fix vacuum crash Vadim found.Bruce Momjian1997-03-09
|
* Reverse patch for Vadims problem.Bruce Momjian1997-03-07
|
* Fix vacuum bug Vadim found with text fields.Bruce Momjian1997-03-06
|
* Not understandable fix of strange bug in vacuum statistic functions.Vadim B. Mikheev1997-03-06
|
* This is a set of single row character functions, defined for the datatypeMarc G. Fournier1997-03-04
| | | | | | text, which are supposed to behave exactly as their Oracle counterparts. From: Edmund Mergl <E.Mergl@bawue.de>
* Patch from Martin due to changes in joinrels.cMarc G. Fournier1997-03-03
|
* Prevent SIGPIPE from crashing server, by Dan McGuirk.Bruce Momjian1997-03-02
|
* Apply date patch from tiemann@cygnus.com,Michael Tiemann.Bruce Momjian1997-03-02
|
* Remove _PAGE_SIZE_ as recommended by Darren King.Bruce Momjian1997-03-02
|
* Remove case-sensitive identifiers. Thanks for Dan McGuirk for a reversal patch.Bruce Momjian1997-03-02
|
* Change machine/limits.h to limits.h.Bruce Momjian1997-03-01
|
* Allow update x =-3, not just x = -3.Bruce Momjian1997-02-28
|
* Remove SUBSYS.o in port/ on clean.Bruce Momjian1997-02-28
|
* Remove win32 port directory. Forgot to do it earlier.Bruce Momjian1997-02-28
|
* Change "WARN" message generated if a unique index is attempted on a table/keyMarc G. Fournier1997-02-25
| | | | containing non-unique data
* Added: UNIQUE feature to bulkload code.Vadim B. Mikheev1997-02-22
|
* Make the error message output by AllocateFile() if failes toMarc G. Fournier1997-02-20
| | | | | open Nulldev a *bit* more user friendly...or, at least, admin friendly...have it print strerror(errno) as well
* Fix for queries with 3 or more relations participating inVadim B. Mikheev1997-02-20
| | | | one clause.
* Prevent under/over flow of float8 constants in parser. Small regression fix.Bruce Momjian1997-02-19
|
* Various cleanups to satisfy -Werror, but there are some errors that I'mMarc G. Fournier1997-02-19
| | | | | not certain how to fix, so left them there and enabled -Wno-error for this directory for now
* rearrange ordering of headers os that postgres.h is firstMarc G. Fournier1997-02-19
|
* Remove WIN32 stuff, and improve conformance to configureMarc G. Fournier1997-02-19
|
* Add and install the pg_geqo.sample fileMarc G. Fournier1997-02-19
|
* Merge in GEQO OptimizerMarc G. Fournier1997-02-19
| | | | From: "Martin S. Utesch" <utesch@aut.tu-freiberg.de>
* Delete -e option to postmaster, keep postgres -e option.Bruce Momjian1997-02-19
|
* Update btree patches that were missed.Bruce Momjian1997-02-18
|
* Clarify clearing of attribute stats memory.Bruce Momjian1997-02-18
|
* Oper_right added, broken with const. conversion.Bruce Momjian1997-02-14
|
* Add prototypes and remove unused variables from btree Fastbuild patch.Bruce Momjian1997-02-14
|
* Remove hardcoded 20000 and change to BootstrapObjectIdData.Bruce Momjian1997-02-14
|
* Remove WIN32 defines. They never worked.Bruce Momjian1997-02-14
|
* Fix naming from proc to prio to fix previous patch.Bruce Momjian1997-02-13
|
* Only allow NULL in the prpoer places.Bruce Momjian1997-02-13
|
* Improvements to the ultrix port, in particular a bunch of compilerMarc G. Fournier1997-02-13
| | | | | | quieting prototyping in port/ultrix4.h Submitted by: Erik Bertelsen <erik@sockdev.uni-c.dk>
* Various patches for nextstep by GregorHoffleitMarc G. Fournier1997-02-13
| | | | Replaced NEED_STRDUP by !HAVE_STRDUP
* Patch for:Marc G. Fournier1997-02-13
| | | | | | | | | The following patch to src/backend/libpq/pqpacket.c provides additional checking for bad packet length data. It was tested with the Linux telnet client, with netcat using the numbers.txt and by dumping random numbers into the port. Patch by: Alvaro Martinez Echevarria <alvaro@lander.es>
* Patch from Massimo Dal Zotto <dz@cs.unitn.it>Marc G. Fournier1997-02-12
| | | | | | | | | | The following patches add to the backend a new debugging flag -K which prints a debug trace of all locking operations on user relations (those with oid greater than 20000). The code is compiled only if LOCK_MGR_DEBUG is defined, so the patch should be harmless if not explicitly enabled. I'm using the code to trace deadlock conditions caused by application queries using the command "$POSTMASTER -D $PGDATA -o '-d 1 -K 1'. The patches are for version 6.0 dated 970126.
* What looks like some *major* improvements to btree indexing...Marc G. Fournier1997-02-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Patches from: aoki@CS.Berkeley.EDU (Paul M. Aoki) i gave jolly my btree bulkload code a long, long time ago but never gave him a bunch of my bugfixes. here's a diff against the 6.0 baseline. for some reason, this code has slowed down somewhat relative to the insertion-build code on very small tables. don't know why -- it used to be within about 10%. anyway, here are some (highly unscientific!) timings on a dec 3000/300 for synthetic tables with 10k, 100k and 1000k tuples (basically, 1mb, 10mb and 100mb heaps). 'c' means clustered (pre-sorted) inputs and 'u' means unclustered (randomly ordered) inputs. the 10k table basically fits in the buffer pool, but the 100k and 1000k tables don't. as you can see, insertion build is fine if you've sorted your heaps on your index key or if your heap fits in core, but is absolutely horrible on unordered data (yes, that's 7.5 hours to index 100mb of data...) because of the zillions of random i/os. if it doesn't work for you for whatever reason, you can always turn it back off by flipping the FastBuild flag in nbtree.c. i don't have time to maintain it. good luck! baseline code: time psql -c 'create index c10 on k10 using btree (c int4_ops)' bttest real 8.6 time psql -c 'create index u10 on k10 using btree (b int4_ops)' bttest real 9.1 time psql -c 'create index c100 on k100 using btree (c int4_ops)' bttest real 59.2 time psql -c 'create index u100 on k100 using btree (b int4_ops)' bttest real 652.4 time psql -c 'create index c1000 on k1000 using btree (c int4_ops)' bttest real 636.1 time psql -c 'create index u1000 on k1000 using btree (b int4_ops)' bttest real 26772.9 bulkloading code: time psql -c 'create index c10 on k10 using btree (c int4_ops)' bttest real 11.3 time psql -c 'create index u10 on k10 using btree (b int4_ops)' bttest real 10.4 time psql -c 'create index c100 on k100 using btree (c int4_ops)' bttest real 59.5 time psql -c 'create index u100 on k100 using btree (b int4_ops)' bttest real 63.5 time psql -c 'create index c1000 on k1000 using btree (c int4_ops)' bttest real 636.9 time psql -c 'create index u1000 on k1000 using btree (b int4_ops)' bttest real 701.0
* Assign priorities when creating jobs in lock queue.Bruce Momjian1997-02-11
|
* Remove machine.h, since it wasn't doing anything that config.h wasn'tMarc G. Fournier1997-02-09
| | | | | | already doing Removed only reference to a machine.h I could find in c.h, to win32/machine.h
* Add attribute optimization statistics.Bruce Momjian1997-02-07
|
* Remove extra paren in ifdef.Bruce Momjian1997-02-06
|
* Various changes to improve/support MklinuxMarc G. Fournier1997-02-06
| | | | Submitted by: Tatsuo Ishii