hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-20 21:37:11 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • d31b20af69 Fix dumping of DEFERRABLE/INITIALLY DEFERRED: Bruce Momjian 2003-01-08 22:54:06 +00:00
  • 5e36cbe6ee Updated deferred trigger patch. Bruce Momjian 2003-01-08 22:29:23 +00:00
  • c77bc1380a This trivial patch implements disabled, deferred triggers, per my proposal on -hackers a couple days ago. The 'tgenabled' status of the trigger is consulted when the trigger is added to the deferred queue (i.e. when the event occurs that fires the trigger), not when the deferred event is executed. Bruce Momjian 2003-01-08 22:28:32 +00:00
  • c9967a4909 Enhanced error/help message for pg_controldata. Bruce Momjian 2003-01-08 22:26:34 +00:00
  • 2d140d35a4 Reconsider old decision to try to constant-fold default and constraint expressions before they are stored. This seems like not such a hot idea, particularly now that the constant-folder will try to inline SQL functions. Tom Lane 2003-01-08 22:06:23 +00:00
  • a899179c8c Repair bug noticed by Deepak Bhole: a shell type should have a dependency on its namespace, so that it will go away if the schema is dropped. Tom Lane 2003-01-08 21:40:49 +00:00
  • 51d2e3bd6e Repair bug noticed by Deepak Bhole: a shell type should have a dependency on its namespace, so that it will go away if the schema is dropped. Tom Lane 2003-01-08 21:40:39 +00:00
  • c8b0ab0bd3 Fix pgpass to work with PQconnectDB(). Bruce Momjian 2003-01-08 21:33:53 +00:00
  • fe7f8f2b91 Fix pgpass to work with PQconnectDB(). Bruce Momjian 2003-01-08 21:33:27 +00:00
  • 40cb1361a6 Fix for bug #866. 7.3 contains new logic for avoiding redundant calls to the index AM when we know we are fetching a unique row. However, this logic did not consider the possibility that it would be asked to fetch backwards. Also fix mark/restore to work correctly in this scenario. Tom Lane 2003-01-08 19:41:57 +00:00
  • cbca6c4896 Fix for bug #866. 7.3 contains new logic for avoiding redundant calls to the index AM when we know we are fetching a unique row. However, this logic did not consider the possibility that it would be asked to fetch backwards. Also fix mark/restore to work correctly in this scenario. Tom Lane 2003-01-08 19:41:40 +00:00
  • 9270f1cdaa Only set the database name if we find a match in the services file. Bruce Momjian 2003-01-08 16:21:53 +00:00
  • 6f14e2771a Correction to last patch. As per the DB-API spec, we need to return None here, not -1. D'Arcy J.M. Cain 2003-01-08 13:42:16 +00:00
  • e38246a643 Add: Bruce Momjian 2003-01-08 06:14:51 +00:00
  • 061168d38f Code review for FETCH/MOVE 0 changes. Improve documentation, do the right thing with the destination when FETCH 0 can't return a row, don't try to stuff LONG_MAX into an int value. Tom Lane 2003-01-08 00:22:27 +00:00
  • 44f47eba8d Backpatch extra slash removal into 7.3.X. HEAD already has it. Bruce Momjian 2003-01-07 22:54:03 +00:00
  • a4ee77543f Fix doc chmod .pgpass line in 7.3.X. Head already fixed. Bruce Momjian 2003-01-07 22:52:50 +00:00
  • 1bc9e98549 SendFunctionResult should take care to detoast varlena results. Tom Lane 2003-01-07 22:32:10 +00:00
  • 9f1f2bfb66 Fix various places where global s/NOTICE/WARNING/ was applied with too much enthusiasm. Tom Lane 2003-01-07 22:23:17 +00:00
  • 9ee86665ef Upgrade to my2pg 1.9 Bruce Momjian 2003-01-07 22:18:49 +00:00
  • 3e40ff58c5 Upgrade to my2pg 1.9 Bruce Momjian 2003-01-07 22:18:43 +00:00
  • b2353a3db6 Upgrade to even newer ora2pg 2.0. Bruce Momjian 2003-01-07 22:17:23 +00:00
  • a24104eb5e Upgrade to even newer ora2pg 2.0. Bruce Momjian 2003-01-07 22:17:14 +00:00
  • de1096bd8e Upgrade to ora2pg 1.10. Backpatch to 7.3.X. Bruce Momjian 2003-01-07 22:16:19 +00:00
  • ffab4fdf24 Upgrade to ora2pg 1.10. Backpatch to 7.3.X. Bruce Momjian 2003-01-07 22:15:56 +00:00
  • 30a800a0e9 Update for new we-always-have-getopt_long approach. Tom Lane 2003-01-07 21:42:38 +00:00
  • b4b62cff93 Apply the proper version of Christopher Kings-Lynne's describe patch (ie, the one with describe-schema support). Minor code review. Adjust display of casts to use standard type names. Tom Lane 2003-01-07 20:56:07 +00:00
  • 1b59b442ce Add connection service file. Bruce Momjian 2003-01-07 20:29:30 +00:00
  • 7320a81ad6 Silence compiler warning caused by removal of netinet/in.h Bruce Momjian 2003-01-07 18:48:13 +00:00
  • 925800cc0b Document that psql \encoding doesn't see SET CLIENT_ENCODING changes. Bruce Momjian 2003-01-07 18:46:52 +00:00
  • cb200245a1 Fix missing tab in file. Bruce Momjian 2003-01-07 15:12:17 +00:00
  • 91ef6b071b Small syntax cleanup. Bruce Momjian 2003-01-07 06:43:20 +00:00
  • 7c97b00e4a Check for sockaddr_in6 for IPv6 code, rather than ip6.h. Bruce Momjian 2003-01-07 06:37:51 +00:00
  • c859cda782 Document libpq service capability, and add sample file. Bruce Momjian 2003-01-07 04:25:29 +00:00
  • 973a210cce Tweak mdnblocks() to avoid doing lseek() on segments that it has previously determined not to be the last segment of a relation. This reduces the expected cost to one seek, rather than one seek per segment. We can get away with this because truncation of a relation will cause a relcache flush and so the md.c file descriptor will be closed; when it is re-opened we will re-determine the last segment. Tom Lane 2003-01-07 01:19:12 +00:00
  • c9cf982038 Enable IPv6 libpq 'hostaddr' addresses. Update docs. Bruce Momjian 2003-01-06 22:48:16 +00:00
  • 939a59ffc6 Use our own version of getopt_long() if the OS doesn't have one. Peter Eisentraut 2003-01-06 18:53:25 +00:00
  • 6e90803f90 Fix for systems that don't have INET_ADDRSTRLEN. Peter Eisentraut 2003-01-06 09:58:36 +00:00
  • 6b39507498 Update comments on IPv6 #define. Bruce Momjian 2003-01-06 06:07:20 +00:00
  • f240746739 Add test for netinet/ip6.h and getaddrinfo, to enable IPv6. Bruce Momjian 2003-01-06 06:06:04 +00:00
  • 895f954f24 Update ipv6 comment, move configure test to the right place Bruce Momjian 2003-01-06 05:46:18 +00:00
  • 2d5e27c637 Add prototype for getaddrinfo(). Bruce Momjian 2003-01-06 05:33:45 +00:00
  • c3e9699f21 Enable IPv6 connections to the server, and add pg_hba.conf IPv6 entries if the OS supports it. Code will still compile on non-IPv6-aware machines (feature added by Bruce). Bruce Momjian 2003-01-06 03:18:27 +00:00
  • d99e7b5a0d Add note explaining that a mergejoinable equality operator is now required if a datatype is to be accepted by GROUP BY, DISTINCT, or ORDER BY. This is documentation for code changes made pursuant to pgsql-hackers discussion around 29-Nov-02. Tom Lane 2003-01-06 01:20:40 +00:00
  • daec989f6a ALTER DOMAIN OWNER, from Rod Taylor. Tom Lane 2003-01-06 00:31:45 +00:00
  • 1bf1597e3a Revert rpath-mangling patch. See discussion on -patches around Nov 29 for the rationale. Peter Eisentraut 2003-01-05 13:45:47 +00:00
  • 2e0e101b42 Fix inherited UPDATE for cases where child column numbering doesn't match parent table. This used to work, but was broken in 7.3 by rearrangement of code that handles targetlist sorting. Add a regression test to catch future breakage. Tom Lane 2003-01-05 00:56:56 +00:00
  • a60f9db508 Fix inherited UPDATE for cases where child column numbering doesn't match parent table. This used to work, but was broken in 7.3 by rearrangement of code that handles targetlist sorting. Add a regression test to catch future breakage. Tom Lane 2003-01-05 00:56:40 +00:00
  • f159bce09f Add missing include --- seems include file references are different in CVS tip than in this branch. Tom Lane 2003-01-05 00:49:59 +00:00
  • b19a0c70d2 Translation updates Peter Eisentraut 2003-01-04 10:26:28 +00:00
  • 17194f4112 Partial code review for ALTER DOMAIN patch. Incorporates Rod Taylor's patches of 9-Dec (permissions fix) and 13-Dec (performance) as well as a partial fix for locking issues: concurrent DROP COLUMN should not create trouble anymore. But concurrent DROP TABLE is still a risk, and there is no protection at all against creating a column of a domain while we are altering the domain. Tom Lane 2003-01-04 00:46:08 +00:00
  • 150ffb2d50 Adjust lo type in contrib during pg_restore so that pg_restore could reload the type. Hiroshi Inoue 2003-01-03 18:05:02 +00:00
  • 4bd41a4d50 Add casts between oid and lo in contrib. Hiroshi Inoue 2003-01-03 15:43:33 +00:00
  • 7e4d4354bc flockfile/funlockfile is POSIX, so NetBSD has them too --- use them. Bruce Momjian 2003-01-02 23:22:49 +00:00
  • 0a02d47a11 Enforces NOT NULL constraints to be applied against new PRIMARY KEY columns in DefineIndex. So, ALTER TABLE ... PRIMARY KEY will now automatically add the NOT NULL constraint. It appeared the alter_table regression test wanted this to occur, as after the change the regression test better matched in inline 'fails'/'succeeds' comments. Tom Lane 2003-01-02 19:29:22 +00:00
  • 3c06dd7f3d Fix BSD/OS thread file locking bug in new fseeko code. Bruce Momjian 2003-01-02 06:01:02 +00:00
  • 2f86f146d9 Fix BSD/OS thread file locking bug in new fseeko code. Bruce Momjian 2003-01-02 06:00:33 +00:00
  • 573fe25203 fastpath code neglected to check whether user has privileges to call the target function. Also, move SetQuerySnapshot() call to avoid assert failure when a fastpath call is attempted in an aborted transaction. Tom Lane 2003-01-01 21:57:18 +00:00
  • d6dbb6b283 fastpath code neglected to check whether user has privileges to call the target function. Also, move SetQuerySnapshot() call to avoid assert failure when a fastpath call is attempted in an aborted transaction. Tom Lane 2003-01-01 21:57:05 +00:00
  • 51225120eb Awhile back I wrote that freebsd.h was probably broken in the places where it diverged from netbsd.h and openbsd.h. This has now been confirmed. Accordingly, make all three exactly alike. Tom Lane 2003-01-01 20:35:54 +00:00
  • a26ac42b76 Awhile back I wrote that freebsd.h was probably broken in the places where it diverged from netbsd.h and openbsd.h. This has now been confirmed. Accordingly, make all three exactly alike. Tom Lane 2003-01-01 20:35:39 +00:00
  • d2a522e483 Update: Bruce Momjian 2003-01-01 19:04:07 +00:00
  • 4a9656f2c2 Add: Bruce Momjian 2002-12-31 18:06:03 +00:00
  • 9ab7ab5196 Add casts between lo and oid. Hiroshi Inoue 2002-12-31 10:22:03 +00:00
  • 699782b695 Adjust Tcl-related code to compile cleanly with Tcl 8.4 (add const modifiers as needed). Some desultory const-ification of SPI interface to support this. Tom Lane 2002-12-30 22:10:54 +00:00
  • d82794ee33 Attached is a patch to provide makefiles, etc. to allow the compilation of the libpq interface static and dynamic libraries with the freely downloadable Borland C++ compiler version 5.5 and/or C++ Builder. Bruce Momjian 2002-12-30 21:07:26 +00:00
  • 896bd121cc Code review for transaction-safe-TRUNCATE patch: minor cleanups. Tom Lane 2002-12-30 19:45:17 +00:00
  • a03c0d93d5 Code review for CLUSTER ALL patch. Fix bogus locking, incorrect transaction stop/start nesting, other infelicities. Tom Lane 2002-12-30 18:42:17 +00:00
  • 2e1f2c3109 Make use of TCL_INCLUDE_SPEC if available (it's new in Tcl 8.4, too bad it took 'em this long to realize it's needed...) Tom Lane 2002-12-30 17:19:54 +00:00
  • 33f0108df8 Cause FETCH 1 to return the current cursor row, or zero if at beginning/end of cursor. Bruce Momjian 2002-12-30 15:31:51 +00:00
  • a0fa0117a5 Better solution to integer overflow problem in hash batch-number computation: reduce the bucket number mod nbatch. This changes the association between original bucket numbers and batches, but that doesn't matter. Minor other cleanups in hashjoin code to help centralize decisions. Tom Lane 2002-12-30 15:21:23 +00:00
  • e533e7dcf5 Add missing slash to python install path. Bruce Momjian 2002-12-30 05:06:50 +00:00
  • 58b95441a4 Add: Bruce Momjian 2002-12-30 04:48:57 +00:00
  • 5271e60ff3 Point does not return a center of lseg. Tom Lane 2002-12-30 02:18:39 +00:00
  • 500ba40915 Point does not return a center of lseg. Tom Lane 2002-12-30 02:18:29 +00:00
  • 629df5f489 Adjust hash table sizing algorithm to avoid integer overflow in ExecHashJoinGetBatch(). Fixes core dump on large hash joins, as in example from Rae Stiening. Tom Lane 2002-12-29 22:29:03 +00:00
  • b33265e9e6 Adjust hash table sizing algorithm to avoid integer overflow in ExecHashJoinGetBatch(). Fixes core dump on large hash joins, as in example from Rae Stiening. Tom Lane 2002-12-29 22:28:50 +00:00
  • c9d8712043 Clean up quoting in configure.in. configure did not change. Bruce Momjian 2002-12-29 03:56:35 +00:00
  • b37d6373f0 Deliver better error message when a relation name is used in an expression. Per report from Ian Barwick. Tom Lane 2002-12-27 20:06:28 +00:00
  • a8a820668a Deliver better error message when a relation name is used in an expression. Per report from Ian Barwick. Tom Lane 2002-12-27 20:06:19 +00:00
  • d5a0f78848 Remove overenthusiastic free'ing of comment dependencies; could lead to core dump in pg_dump when dumping views having comments. See bug #855. Tom Lane 2002-12-27 17:10:55 +00:00
  • 6c08905d4c Remove overenthusiastic free'ing of comment dependencies; could lead to core dump in pg_dump when dumping views having comments. See bug #855. Tom Lane 2002-12-27 17:10:45 +00:00
  • 0b91b448f4 Small fix in documentation and some examples of usage. Please, apply to 7.3 and current CVS Bruce Momjian 2002-12-27 14:10:49 +00:00
  • 1868b0be44 Small fix in documentation and some examples of usage. Please, apply to 7.3 and current CVS Bruce Momjian 2002-12-27 14:10:29 +00:00
  • 31f7f574bd Trivial patch to increase max_fsm_pages as per earlier discussion. Bruce Momjian 2002-12-27 14:07:14 +00:00
  • 9a39ba4b0f Trivial patch to increase max_fsm_pages as per earlier discussion. Bruce Momjian 2002-12-27 14:06:34 +00:00
  • 7288439999 Added: Bruce Momjian 2002-12-27 05:56:53 +00:00
  • f772e6cbf7 Clamp the output of estimate_hash_bucketsize() to a sane range; per example from Bruno Wolff in which it produced a silly result. Tom Lane 2002-12-26 23:38:42 +00:00
  • 1dfbbd51e7 Don't try to free executor state of an InitPlan early --- this breaks EXPLAIN ANALYZE. (Premature optimization is the root of all evil?) Tom Lane 2002-12-26 22:37:42 +00:00
  • 061d4e2079 Add developer organizations: Bruce Momjian 2002-12-24 22:06:53 +00:00
  • 7c3e3cd96a Update SSL error message for improper permissions. Backpatch to 7.3.X. Bruce Momjian 2002-12-23 22:19:26 +00:00
  • 572d95150e Update SSL error message for improper permissions. Backpatch to 7.3.X. Bruce Momjian 2002-12-23 22:19:00 +00:00
  • 3daad2ae91 case sensitive updates by Kris Jurka Dave Cramer 2002-12-23 16:12:36 +00:00
  • b222867534 pg_dump should consider information_schema to be a system schema. Also, tweak -C option (emit CREATE DATABASE command) to emit encoding name rather than encoding number, for consistency with pg_dumpall and better cross-version portability. Tom Lane 2002-12-21 22:45:09 +00:00
  • a3feaba9aa Fix possible buffer overrun in \d command: substr(..., 128) produces a result of at most 128 chars, but that could be more than 128 bytes. Also ensure we don't try to pfree uninitialized pointers during error cleanup. REL7_3_1 Tom Lane 2002-12-21 01:07:21 +00:00
  • f1f5978603 Fix possible buffer overrun in \d command: substr(..., 128) produces a result of at most 128 chars, but that could be more than 128 bytes. Also ensure we don't try to pfree uninitialized pointers during error cleanup. Tom Lane 2002-12-21 01:07:07 +00:00
  • e2ad5816e2 mike beachy's patch for statement handling Dave Cramer 2002-12-20 14:10:34 +00:00
  • 83feff3ee7 patch for null table in getPrimaryKeys Dave Cramer 2002-12-20 13:15:53 +00:00
  • 96bce9f689 Update 7.3.1 to give proper attribution to pg_dump item. Bruce Momjian 2002-12-20 00:24:29 +00:00
  • ff494e8851 Update 7.3.1 to give proper attribution to pg_dump item. Bruce Momjian 2002-12-20 00:24:00 +00:00