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

  • 2eafcf68d5 Restructure the code in copyfuncs and equalfuncs to put much heavier reliance on macros, in hopes of eliminating silly typos (like copying to the wrong field) and just generally making it easier to see the forest instead of the trees. As an example, here is the new code for A_Indices: Tom Lane 2002-11-25 03:33:27 +00:00
  • 200dd8e3f8 I'm sending you a small patch to pgdb.py module. This raises pgdb.DatabaseError when any of the fetch* methods was invoked but previous call to execute* did not produce any result set or no call was issued yet. Also, raises pgdb.NotSupportedError when .nextset() is invoked, instead of NameError. D'Arcy J.M. Cain 2002-11-25 03:11:15 +00:00
  • a4bc5eeef2 Change the pkey method so that the caller can optionally set the dictionary used for the primary key lookup. This will prevent a database lookup for each connection object that gets created. This could be a significant optimization on a busy system. D'Arcy J.M. Cain 2002-11-25 02:15:13 +00:00
  • f393ee0680 Change the debug variable to allow better control by the caller over how debug output is managed. The user can continue to use the current method of passing a formatting string to have a replacement done and output will be sent to the standard output exactly as it did before. In addition they can set it to a file object, sys.stderr for example, and the query string will be printed to it. Thay can also set it to a method (function) and the query string will be passed to that method giving them the maximum flexibility to do whatever they want with the query string. D'Arcy J.M. Cain 2002-11-25 01:28:32 +00:00
  • 04c8785c7b Restructure planning of nestloop inner indexscans so that the set of usable joinclauses is determined accurately for each join. Formerly, the code only considered joinclauses that used all of the rels from the outer side of the join; thus for example FROM (a CROSS JOIN b) JOIN c ON (c.f1 = a.x AND c.f2 = b.y) could not exploit a two-column index on c(f1,f2), since neither of the qual clauses would be in the joininfo list it looked in. The new code does this correctly, and also is able to eliminate redundant clauses, thus fixing the problem noted 24-Oct-02 by Hans-Jürgen Schönig. Tom Lane 2002-11-24 21:52:15 +00:00
  • 6bfc09baf4 7.4devel now supports SQL:1999's "enhanced trigger capability" (which is just FOR EACH STATEMENT triggers, AFAICS); this patch updates the SQL conformance docs to note that. Bruce Momjian 2002-11-24 03:15:55 +00:00
  • 1676753e2b Split: Bruce Momjian 2002-11-24 03:14:01 +00:00
  • 027a39726f Fix inappropriate quoting in dblink. From Joe Conway. Tom Lane 2002-11-23 18:59:29 +00:00
  • 11d337185d Fix inappropriate quoting in dblink. From Joe Conway. Tom Lane 2002-11-23 18:59:25 +00:00
  • c3637205b2 Fix regression test breakage from triggers patch. Tom Lane 2002-11-23 18:42:37 +00:00
  • 4c61c827d3 Fix compile warnings from truncate patch. Tom Lane 2002-11-23 18:26:45 +00:00
  • 17d938320d Update regression for new patches. Bump up catversion. Bruce Momjian 2002-11-23 18:13:22 +00:00
  • f9e23827b0 Heres a patch which will create the sql_help.h file on Win32 if it doesn't already exist using an installed copy of perl. I've tested it using perl v5.6.1 from ActiveState and all appears to work. Bruce Momjian 2002-11-23 04:06:32 +00:00
  • d46f3de363 Transaction safe Truncate Bruce Momjian 2002-11-23 04:05:52 +00:00
  • a2b4a7071d This minor patch corrects an error in the function docs: it's "version()", not "version". Bruce Momjian 2002-11-23 04:04:43 +00:00
  • 1b7f3cc02d This patch implements FOR EACH STATEMENT triggers, per my email to -hackers a couple days ago. Bruce Momjian 2002-11-23 03:59:09 +00:00
  • ea29b32758 Done: Bruce Momjian 2002-11-23 03:52:44 +00:00
  • c464212421 When I made the cube(text) function for 7.3, I neglected to add a matching create cast command. The attached diff adds a create cast as assignment to cube.sql.in . Bruce Momjian 2002-11-23 03:50:50 +00:00
  • b9840c0828 Update ports list from recent regression-test-database entries. Tom Lane 2002-11-23 03:50:39 +00:00
  • 9416f3839d Update ports list from recent regression-test-database entries. Tom Lane 2002-11-23 03:50:34 +00:00
  • 4987ca2d88 This is a patch to make cube output work like double precision output with regard to the extra_float_digits setting. Bruce Momjian 2002-11-23 03:50:21 +00:00
  • a43979edfb Release note improvements (Neil, Tom) Tom Lane 2002-11-23 02:41:10 +00:00
  • 349d529abf Release note improvements (Neil, Tom) Tom Lane 2002-11-23 02:41:03 +00:00
  • 4f22c3bcfb Remove inappropriate double-quoting in connectby() code; adjust regression test to avoid using VALUE as a name. From Joe Conway. Tom Lane 2002-11-23 01:54:23 +00:00
  • 1f1c332381 Remove inappropriate double-quoting in connectby() code; adjust regression test to avoid using VALUE as a name. From Joe Conway. Tom Lane 2002-11-23 01:54:09 +00:00
  • e760d22391 Redesign internal logic of nodeLimit so that it does not need to fetch one more row from the subplan than the COUNT would appear to require. This costs a little more logic but a number of people have complained about the old implementation. Tom Lane 2002-11-22 22:10:01 +00:00
  • 55994bab8e Fix a dozen or so places that were passing unpredictable data strings as elog format strings. Hai-Chen Tu pointed out the problem in contrib/dbmirror, but it wasn't the only such error. Tom Lane 2002-11-22 16:25:55 +00:00
  • 95c9c22633 Fix a dozen or so places that were passing unpredictable data strings as elog format strings. Hai-Chen Tu pointed out the problem in contrib/dbmirror, but it wasn't the only such error. Tom Lane 2002-11-22 16:25:32 +00:00
  • 7082e7e43a Fix elog in dbmirror to use %s. Bruce Momjian 2002-11-22 16:05:06 +00:00
  • eeec0a6775 Fix elog in dbmirror to use %s. Bruce Momjian 2002-11-22 16:04:41 +00:00
  • 1e68232b35 Quote database name properly when invoking pg_dump. Per report from Christopher Kings-Lynne. Tom Lane 2002-11-22 03:09:59 +00:00
  • 1f79360907 Quote database name properly when invoking pg_dump. Per report from Christopher Kings-Lynne. Tom Lane 2002-11-22 03:09:43 +00:00
  • 5fe20771d5 TAS code originally written for s390 (32-bit) does not work for s390x (64-bit). Fix it. Per report from Permaine Cheung. Tom Lane 2002-11-22 01:13:28 +00:00
  • fadcb01177 TAS code originally written for s390 (32-bit) does not work for s390x (64-bit). Fix it. Per report from Permaine Cheung. Tom Lane 2002-11-22 01:13:16 +00:00
  • ed24f28538 Fixups for man pages Peter Eisentraut 2002-11-21 23:34:43 +00:00
  • 4a0e9b6936 Regenerate Peter Eisentraut 2002-11-21 23:33:22 +00:00
  • f3fa6c6ba1 Fixups for man pages Peter Eisentraut 2002-11-21 23:31:58 +00:00
  • 4dc8a0e4e1 Fix breakage in new-in-7.3 timetz_zone() function: was giving random results due to doing arithmetic on uninitialized values. Add some documentation about the AT TIME ZONE construct. Update some other date/time documentation that seemed out of date for 7.3. Tom Lane 2002-11-21 23:31:37 +00:00
  • 75394d3f5b Fix breakage in new-in-7.3 timetz_zone() function: was giving random results due to doing arithmetic on uninitialized values. Add some documentation about the AT TIME ZONE construct. Update some other date/time documentation that seemed out of date for 7.3. Tom Lane 2002-11-21 23:31:20 +00:00
  • 040d0ae95d Regenerate Peter Eisentraut 2002-11-21 23:31:09 +00:00
  • ca1d1b79ab Wups, stuck ORDER BY on wrong query while trying to eliminate random ordering of GROUP BY output due to hash-based aggregation. Tom Lane 2002-11-21 22:26:02 +00:00
  • 63c38401d9 Add: Bruce Momjian 2002-11-21 19:15:04 +00:00
  • 71f411dd03 Add mention of kern.ipc.shm_use_phys for locking shared memory. Bruce Momjian 2002-11-21 18:19:51 +00:00
  • eda8dd8b2d Code review for superuser_reserved_connections patch. Don't try to do database access outside a transaction; revert bogus performance improvement in SIBackendInit(); improve comments; add documentation (this part courtesy Neil Conway). Tom Lane 2002-11-21 06:36:27 +00:00
  • 8362be35e8 Code review for superuser_reserved_connections patch. Don't try to do database access outside a transaction; revert bogus performance improvement in SIBackendInit(); improve comments; add documentation (this part courtesy Neil Conway). Tom Lane 2002-11-21 06:36:08 +00:00
  • 6d227ae782 NetBSD versions 1.6 and (we hope) later can use the standard geometry comparison file, instead of geometry-positive-zeros. Per report from Patrick Welche. Tom Lane 2002-11-21 04:40:41 +00:00
  • 02d83d7565 NetBSD versions 1.6 and (we hope) later can use the standard geometry comparison file, instead of geometry-positive-zeros. Per report from Patrick Welche. Tom Lane 2002-11-21 04:40:26 +00:00
  • 1c6adf0f67 Done: Bruce Momjian 2002-11-21 01:02:34 +00:00
  • 9b3bcdd41f This locale-specific variant file seems not to have been updated when a test was added to select_having.sql back in June. Tom Lane 2002-11-21 00:45:18 +00:00
  • 6c1d4662af Finish implementation of hashed aggregation. Add enable_hashagg GUC parameter to allow it to be forced off for comparison purposes. Add ORDER BY clauses to a bunch of regression test queries that will otherwise produce randomly-ordered output in the new regime. Tom Lane 2002-11-21 00:42:20 +00:00
  • f25d3a5044 Update ports list. Bruce Momjian 2002-11-20 22:02:25 +00:00
  • 2676e11fdf Update ports list. Bruce Momjian 2002-11-20 22:01:57 +00:00
  • ce35ce91f9 Fix a stupid cut and paste error from the commit last night. Barry Lind 2002-11-20 20:42:24 +00:00
  • 1b80e0122f Fix a dumb cut and paste error from my last commit and update some of the jdbc3 metadata responses Barry Lind 2002-11-20 20:37:53 +00:00
  • e994389d7b Backport bug with executeBatch. This bug was a regression from 7.2 and has been reported by Marko Strukelj and Keith Wannamaker Barry Lind 2002-11-20 07:54:27 +00:00
  • 54bc3b6b8b Fixed bug reported by Marko Strukelj and Keith Wannamaker. Using executeBatch on a preparedStatement would reset the prepared statment causing subsequent uses of the preparedStatement to fail (i.e. the following series of calls would fail: addBatch() executeBatch() addBatch() executBatch()). This is a regression from 7.2 where this worked correctly. The regression test has also been modified to explicitly test for this case. Barry Lind 2002-11-20 07:34:32 +00:00
  • b60be3f2f8 Add an at-least-marginally-plausible method of estimating the number of groups produced by GROUP BY. This improves the accuracy of planning estimates for grouped subselects, and is needed to check whether a hashed aggregation plan risks memory overflow. Tom Lane 2002-11-19 23:22:00 +00:00
  • 54cb1db6cf Add my name: Bruce Momjian 2002-11-19 20:35:13 +00:00
  • 988dbc58a2 Update regression for ALL missing from CLUSTER. Bruce Momjian 2002-11-19 17:39:00 +00:00
  • af26857a27 Most of the code follows the American spelling of the word, which is "canceled", so I changed the one remaining usage of the British spelling ("cancelled") over to the former, and updated the translation files appropriately. Bruce Momjian 2002-11-19 17:21:40 +00:00
  • f06cc8a832 Back out NetBSD/arm32 port. Bruce Momjian 2002-11-19 17:18:14 +00:00
  • cd55a2b1be Back out NetBSD/arm32 port. Bruce Momjian 2002-11-19 17:17:48 +00:00
  • 98c65faa4d Update ports list. Bruce Momjian 2002-11-19 16:40:49 +00:00
  • 7b5571e83d Update ports list. Bruce Momjian 2002-11-19 16:40:05 +00:00
  • 267e9388f7 Fix markup breakage. Bruce Momjian 2002-11-18 19:30:33 +00:00
  • ded8f887aa Fix typo and markup. Peter Eisentraut 2002-11-18 18:10:59 +00:00
  • 515d41266e Fix typo and markup. Peter Eisentraut 2002-11-18 18:08:22 +00:00
  • 075f482024 Update SGML problem in ports. Bruce Momjian 2002-11-18 17:15:27 +00:00
  • c4501ec551 Remove ALL from CLUSTER ALL. Use just CLUSTER. Bruce Momjian 2002-11-18 17:12:07 +00:00
  • 14ebe833e2 Update ports list. Bruce Momjian 2002-11-18 05:02:34 +00:00
  • 72cf681383 Update ports list. Bruce Momjian 2002-11-18 05:02:08 +00:00
  • 427c889607 Stamp RC2. Bruce Momjian 2002-11-18 04:41:14 +00:00
  • 77c94aca72 Put back error test for DECLARE CURSOR outside a transaction block ... but do it correctly now. Tom Lane 2002-11-18 01:17:50 +00:00
  • 17ac74797a Put back error test for DECLARE CURSOR outside a transaction block ... but do it correctly now. Tom Lane 2002-11-18 01:17:39 +00:00
  • 810f2cfa32 Suppress compile warning, avoid possible problems with signed vs. unsigned comparisons in recently-added CheckPointWarning code. Tom Lane 2002-11-18 00:40:46 +00:00
  • 38e6eb197d Re-order REINDEX options in manual for consistency. REINDEX DATABASE/TABLE/INDEX is the proper order. Bruce Momjian 2002-11-17 23:43:32 +00:00
  • 8fbef3b55d Reduce need for palloc/pfree overhead in varstr_cmp() by using fixed-size buffers on stack for short strings. Tom Lane 2002-11-17 23:01:30 +00:00
  • 35223af057 Revise SQL features list. Peter Eisentraut 2002-11-17 13:28:43 +00:00
  • 6a51c59333 Revise SQL features list. Peter Eisentraut 2002-11-17 13:17:55 +00:00
  • bf25ad354e mis-tag'd as the release instead of rc1 ... PostgreSQL Daemon 2002-11-16 19:48:30 +00:00
  • 00e59b5ec2 Fix CLUSTER regression failure caused by new patch, from Neil Conway Bruce Momjian 2002-11-16 03:25:22 +00:00
  • cab72f57d5 Update TODO/FAQ for 7.3 release. Bruce Momjian 2002-11-16 02:34:22 +00:00
  • 19826a77af Update for RC1. Bruce Momjian 2002-11-16 02:21:21 +00:00
  • 24b130cb89 Add relcache support for system catalogs with attnotnull columns. The code was not making TupleConstr structs for such catalogs in several places; with the consequence that the not-null constraint wasn't actually enforced. With this change, INSERT INTO pg_proc VALUES('sdf'); generates a 'Fail to add null value' error instead of a core dump. Tom Lane 2002-11-15 17:18:49 +00:00
  • 4bc3598aa4 Synced parser. Michael Meskes 2002-11-15 15:47:44 +00:00
  • 9249bdaabd SGML markup fixes. Bruce Momjian 2002-11-15 03:22:30 +00:00
  • da8149032a SGML improvements. Bruce Momjian 2002-11-15 03:11:18 +00:00
  • 8bc717cb88 New version attached. The following is implemented: Bruce Momjian 2002-11-15 03:09:39 +00:00
  • 5b7eb4dd45 Clean up psql: Bruce Momjian 2002-11-15 03:07:52 +00:00
  • 728fa75edc OpenSSL 0.9.6g in Debian/unstable stopped working with pgcrypto. This is pgcrypto bug as it assumed too much about inner workings of OpenSSL. Bruce Momjian 2002-11-15 02:54:44 +00:00
  • 93e54678a3 pg_dump for domain constraints. Bruce Momjian 2002-11-15 02:52:18 +00:00
  • 6b603e67dc Add DOMAIN check constraints. Bruce Momjian 2002-11-15 02:50:21 +00:00
  • 2986aa6a66 Add checkpoint_warning to warn of excessive checkpoints caused by too few WAL files. Bruce Momjian 2002-11-15 02:44:57 +00:00
  • 779eb54142 Push qual clauses containing subplans to the back of the qual list at each plan node. Per gripe from Ross Reedstrom. Tom Lane 2002-11-15 02:37:08 +00:00
  • 3779f7fd9f Push qual clauses containing subplans to the back of the qual list at each plan node. Per gripe from Ross Reedstrom. Tom Lane 2002-11-15 02:36:53 +00:00
  • c948a3f4b8 Rename hostname_lookup to log_hostname. Bruce Momjian 2002-11-15 01:57:28 +00:00
  • aead49667b Rename show_source_port to log_source_port. Bruce Momjian 2002-11-15 01:40:20 +00:00
  • 559b6c7ced Rename show_btree_build_stats to log_btree_build_stats Bruce Momjian 2002-11-15 01:26:09 +00:00
  • d36aa2e885 Rename: Bruce Momjian 2002-11-15 00:47:22 +00:00
  • 001d5a7aa5 Rename server_min_messages to log_min_messages. Part of consolidation of log_ settings. Bruce Momjian 2002-11-14 23:53:27 +00:00