hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-04-10 14:57:01 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • e138b80996 String fix Peter Eisentraut 2006-11-16 14:28:41 +00:00
  • 2b7cef5fb3 Improve broadcast wording for failover/clustering documentation. Bruce Momjian 2006-11-15 01:09:08 +00:00
  • 9497454ca6 Add URL for case identifiers. < > http://archives.postgresql.org/pgsql-hackers/2006-10/msg01527.php Bruce Momjian 2006-11-14 22:26:49 +00:00
  • 0fc2947729 Fix xrefs for failover changes. Bruce Momjian 2006-11-14 22:25:15 +00:00
  • ca21417a34 Update failover docs, per suggestions from Chris Browne. Bruce Momjian 2006-11-14 21:43:00 +00:00
  • 77f24a46b7 Fix URL for patch hold queue. Bruce Momjian 2006-11-14 04:18:55 +00:00
  • 751e3e6bd8 Force plperl and plperlu to run in separate interpreters. Create an error on an attempt to create the second interpreter if this is not supported by the perl installation. Per recent -hackers discussion. Andrew Dunstan 2006-11-13 17:13:57 +00:00
  • dc10387eb1 Fix some typos in comments. Neil Conway 2006-11-12 06:55:54 +00:00
  • f49baa73ef Do a round of copy-editing for the system catalog chapter. In particular, consistently capitalize the content of the "Description" column but do not include a terminating period, as is the convention elsewhere in the docs. Also, remove the "References" column from catalog that do not have any referencing columns, for the sake of brevity. Make various other SGML and grammar fixes. Neil Conway 2006-11-12 06:25:37 +00:00
  • 2b5fedc0d7 Minor improvements to the description of archive_timeout. Neil Conway 2006-11-12 05:12:42 +00:00
  • a46ca619f8 Suppress a few 'uninitialized variable' warnings that gcc emits only at -O3 or higher (presumably because it inlines more things). Per gripe from Mark Mielke. Tom Lane 2006-11-11 01:14:19 +00:00
  • d13f372acd Fix pg_get_serial_sequence(), which could incorrectly return the name of an index on a serial column, rather than the name of the associated sequence. Fallout from recent changes in dependency setup for serials. Per bug #2732 from Basil Evseenko. Tom Lane 2006-11-10 22:59:29 +00:00
  • 792d6edd5b Clean up some misleading references to %p being a full path, per Simon. Tom Lane 2006-11-10 22:32:20 +00:00
  • 1456c5b507 Improve formatting of PQexecParams argument descriptions, per Theo Kramer. Tom Lane 2006-11-10 22:15:26 +00:00
  • 2c2faa17f2 Emphasize that immutable and stable functions are not allowed to modify the database. xfunc.sgml was already pretty definite on the point, but it doesn't hurt to make it clear here too. Tom Lane 2006-11-10 20:52:18 +00:00
  • 33556af7c7 Fix errors in key_column_usage.position_in_unique_constraint column recently added to information_schema (per a SQL2003 addition). The original coding failed if a referenced column participated in more than one pg_constraint entry. Also, it did not work if an FK relied directly on a unique index without any constraint syntactic sugar --- this case is outside the SQL spec, but PG has always supported it, so it's reasonable for our information_schema to handle it too. Per bug#2750 from Stephen Haberman. Tom Lane 2006-11-10 18:10:10 +00:00
  • 87a50169d2 Minor code cleanup for pgcrypto: for UDFs declared to be strict, checking for NULL-ness of function arguments is wasted code. Neil Conway 2006-11-10 06:28:29 +00:00
  • d19798e584 Fix set_joinrel_size_estimates() to estimate outer-join sizes more accurately: we have to distinguish the effects of the join's own ON clauses from the effects of pushed-down clauses. Failing to do so was a quick hack long ago, but it's time to be smarter. Per example from Thomas H. Tom Lane 2006-11-10 01:21:41 +00:00
  • dcbdf9b1d4 Change Windows rename and unlink substitutes so that they time out after 30 seconds instead of retrying forever. Also modify xlog.c so that if it fails to rename an old xlog segment up to a future slot, it will unlink the segment instead. Per discussion of bug #2712, in which it became apparent that Windows can handle unlinking a file that's being held open, but not renaming it. Tom Lane 2006-11-08 20:12:05 +00:00
  • 808b3190d1 Modify aset.c to track the next intended block allocation size explicitly. The former coding relied on the actual allocated size of the last block, which made it behave strangely if the first allocation in a context was larger than ALLOC_CHUNK_LIMIT: subsequent allocations would be referenced to that and not to the intended series of block sizes. Noted while studying a memory wastage gripe from Tatsuo. Tom Lane 2006-11-08 19:27:24 +00:00
  • fc5eb3f69a Tweak accumArrayResult() to double the size of its working arrays when more space is needed, instead of incrementing by a fixed amount; the old method wastes lots of space and time when the ultimate size is large. Per gripe from Tatsuo. Tom Lane 2006-11-08 19:24:38 +00:00
  • a5cf12e2ef Fix performance issues in replace_text(), replace_text_regexp(), and text_to_array(): they all had O(N^2) behavior on long input strings in multibyte encodings, because of repeated rescanning of the input text to identify substrings whose positions/lengths were computed in characters instead of bytes. Fix by tracking the current source position as a char pointer as well as a character-count. Also avoid some unnecessary palloc operations. text_to_array() also leaked memory intracall due to failure to pfree temporary strings. Per gripe from Tatsuo Ishii. Tom Lane 2006-11-08 19:22:25 +00:00
  • 9d6f26325f Fix two typos. Neil Conway 2006-11-08 19:06:15 +00:00
  • 092ed294fc New README, forgotten when docs was updated Teodor Sigaev 2006-11-08 16:00:29 +00:00
  • a2281c8e6f Applied patch by Peter Harris to free auto_mem struct in ECPGconnect. Michael Meskes 2006-11-08 10:48:27 +00:00
  • 171f936b51 Applied patch by Peter Harris to free auto_mem struct in ECPGconnect. Michael Meskes 2006-11-08 10:48:21 +00:00
  • 0c96e42797 Applied patch by Peter Harris to free auto_mem structure on connect Michael Meskes 2006-11-08 10:46:47 +00:00
  • 415b925345 Fix a memory leak in psql: we'd leak a few PGresult handles if a connectivity error occurred while executing one of the queries for "\d <table>". Not serious, but still worth fixing. Patch from Brendan Jurd. Neil Conway 2006-11-08 01:22:55 +00:00
  • 8964b41c7b Remove a 15-year old comment questioning behavior that is now well- established: referencing an undefined parameter should result in an error, not NULL. Neil Conway 2006-11-08 00:45:30 +00:00
  • 9b3aee524f Tag as Beta3 ... two outstanding *known* bugs before RC1 ... REL8_2_BETA3 PostgreSQL Daemon 2006-11-07 17:59:05 +00:00
  • 5ae883f52b Repair bug #2694 concerning an ARRAY[] construct whose inputs are empty sub-arrays. Per discussion, if all inputs are empty arrays then result must be an empty array too, whereas a mix of empty and nonempty arrays should (and already did) draw an error. In the back branches, the construct was strict: any NULL input immediately yielded a NULL output; so I left that behavior alone. HEAD was simply ignoring NULL sub-arrays, which doesn't seem very sensible. For lack of a better idea it now treats NULL sub-arrays the same as empty ones. Tom Lane 2006-11-06 18:21:58 +00:00
  • fc8c5fbf5d Repair bug #2694 concerning an ARRAY[] construct whose inputs are empty sub-arrays. Per discussion, if all inputs are empty arrays then result must be an empty array too, whereas a mix of empty and nonempty arrays should (and already did) draw an error. In the back branches, the construct was strict: any NULL input immediately yielded a NULL output; so I left that behavior alone. HEAD was simply ignoring NULL sub-arrays, which doesn't seem very sensible. For lack of a better idea it now treats NULL sub-arrays the same as empty ones. Tom Lane 2006-11-06 18:21:47 +00:00
  • b3234f2912 Repair bug #2694 concerning an ARRAY[] construct whose inputs are empty sub-arrays. Per discussion, if all inputs are empty arrays then result must be an empty array too, whereas a mix of empty and nonempty arrays should (and already did) draw an error. In the back branches, the construct was strict: any NULL input immediately yielded a NULL output; so I left that behavior alone. HEAD was simply ignoring NULL sub-arrays, which doesn't seem very sensible. For lack of a better idea it now treats NULL sub-arrays the same as empty ones. Tom Lane 2006-11-06 18:21:38 +00:00
  • f0395d50e9 Repair bug #2694 concerning an ARRAY[] construct whose inputs are empty sub-arrays. Per discussion, if all inputs are empty arrays then result must be an empty array too, whereas a mix of empty and nonempty arrays should (and already did) draw an error. In the back branches, the construct was strict: any NULL input immediately yielded a NULL output; so I left that behavior alone. HEAD was simply ignoring NULL sub-arrays, which doesn't seem very sensible. For lack of a better idea it now treats NULL sub-arrays the same as empty ones. Tom Lane 2006-11-06 18:21:31 +00:00
  • 36e012e727 Remove temporary Windows-specific debugging code; it seems the problem with fopen() not using FILE_SHARE_DELETE was indeed the bug we were after, given lack of recent reports. Tom Lane 2006-11-06 17:10:22 +00:00
  • 9c3f24bb46 Update release notes in preparation for RC1. Tom Lane 2006-11-06 17:00:27 +00:00
  • 02f37bd8c4 Revert to the pre-8.2 method of probing for libm, that is, always include it if it links properly. It seems too risky to assume that standard functions like pow() are not special-cased by the compiler. Per report from Andreas Lange that build fails on Solaris cc compiler with -fast. Even though we don't consider that a supported option, I'm worried that similar issues will arise with other compilers. Tom Lane 2006-11-06 03:44:38 +00:00
  • 74686b6de7 Get rid of some unnecessary dependencies on DataDir: wherever possible, the backend should rely on its working-directory setting instead. Also do some message-style police work in contrib/adminpack. Tom Lane 2006-11-06 03:06:41 +00:00
  • 62fe410ec6 Minor fix for LDAP authentication: if an error occurs, we need to manually release the LDAP handle via ldap_unbind(). This isn't a significant problem in practice because an error eventually results in exiting the process, but we can cleanup correctly without too much pain. Neil Conway 2006-11-06 01:27:52 +00:00
  • befd4e4e48 Fix recently-identified PITR recovery hazard: the base backup could contain stale relcache init files (pg_internal.init), and there is no mechanism for updating them during WAL replay. Easiest solution is just to delete the init files at conclusion of startup, and let the first backend started in each database take care of rebuilding the init file. Simon Riggs and Tom Lane. Tom Lane 2006-11-05 23:40:38 +00:00
  • 76d5667ba8 Fix recently-identified PITR recovery hazard: the base backup could contain stale relcache init files (pg_internal.init), and there is no mechanism for updating them during WAL replay. Easiest solution is just to delete the init files at conclusion of startup, and let the first backend started in each database take care of rebuilding the init file. Simon Riggs and Tom Lane. Tom Lane 2006-11-05 23:40:31 +00:00
  • 48188e1621 Fix recently-understood problems with handling of XID freezing, particularly in PITR scenarios. We now WAL-log the replacement of old XIDs with FrozenTransactionId, so that such replacement is guaranteed to propagate to PITR slave databases. Also, rather than relying on hint-bit updates to be preserved, pg_clog is not truncated until all instances of an XID are known to have been replaced by FrozenTransactionId. Add new GUC variables and pg_autovacuum columns to allow management of the freezing policy, so that users can trade off the size of pg_clog against the amount of freezing work done. Revise the already-existing code that forces autovacuum of tables approaching the wraparound point to make it more bulletproof; also, revise the autovacuum logic so that anti-wraparound vacuuming is done per-table rather than per-database. initdb forced because of changes in pg_class, pg_database, and pg_autovacuum catalogs. Heikki Linnakangas, Simon Riggs, and Tom Lane. Tom Lane 2006-11-05 22:42:10 +00:00
  • 10c70b8602 Add note about space usage of 'manual' approach to clustering, per suggestion from Sergey Koposov. Also some other minor editing. Tom Lane 2006-11-04 19:03:51 +00:00
  • 23092b9928 Correct documentation error: in 8.1 and 8.2, %p in archive and restore command strings inserts relative not absolute path of file to process. This is a side-effect of 2005-07-04 change that makes the server use relative paths in general. Noted by Bernd Helmle. Tom Lane 2006-11-04 18:20:40 +00:00
  • 6fada49805 Correct documentation error: in 8.1 and 8.2, %p in archive and restore command strings inserts relative not absolute path of file to process. This is a side-effect of 2005-07-04 change that makes the server use relative paths in general. Noted by Bernd Helmle. Tom Lane 2006-11-04 18:20:27 +00:00
  • 17a814ca02 Mention 'void' as the proper return type when there's nothing to return, per suggestion from Joachim Wieland. Tom Lane 2006-11-03 07:17:36 +00:00
  • 4e4c165dad Fix "failed to re-find parent key" btree VACUUM failure by tweaking _bt_pagedel to recover from the failure: just search the whole parent level if searching to the right fails. This does nothing for the underlying problem that index keys became out-of-order in the grandparent level. However, we believe that there is no other consequence worse than slightly inefficient searching, so this narrow patch seems like the safest solution for the back branches. Tom Lane 2006-11-01 19:50:15 +00:00
  • b4f5429fa8 Fix "failed to re-find parent key" btree VACUUM failure by tweaking _bt_pagedel to recover from the failure: just search the whole parent level if searching to the right fails. This does nothing for the underlying problem that index keys became out-of-order in the grandparent level. However, we believe that there is no other consequence worse than slightly inefficient searching, so this narrow patch seems like the safest solution for the back branches. Tom Lane 2006-11-01 19:50:08 +00:00
  • 6f48f84874 Fix "failed to re-find parent key" btree VACUUM failure by tweaking _bt_pagedel to recover from the failure: just search the whole parent level if searching to the right fails. This does nothing for the underlying problem that index keys became out-of-order in the grandparent level. However, we believe that there is no other consequence worse than slightly inefficient searching, so this narrow patch seems like the safest solution for the back branches. Tom Lane 2006-11-01 19:50:03 +00:00
  • 70ce5c9082 Fix "failed to re-find parent key" btree VACUUM failure by revising page deletion code to avoid the case where an upper-level btree page remains "half dead" for a significant period of time, and to block insertions into a key range that is in process of being re-assigned to the right sibling of the deleted page's parent. This prevents the scenario reported by Ed L. wherein index keys could become out-of-order in the grandparent index level. Tom Lane 2006-11-01 19:43:17 +00:00
  • ecaa7ebed8 pg_restore failed on tar-format archives if they contained large objects (blobs) with comments, per bug #2727 from Konstantin Pelepelin. Mea culpa for not having tested this case. Back-patch to 8.1; prior branches don't dump blob comments at all. Tom Lane 2006-11-01 15:59:31 +00:00
  • 19d0c46def pg_restore failed on tar-format archives if they contained large objects (blobs) with comments, per bug #2727 from Konstantin Pelepelin. Mea culpa for not having tested this case. Back-patch to 8.1; prior branches don't dump blob comments at all. Tom Lane 2006-11-01 15:59:26 +00:00
  • c1fdbba49f Update zic database to tzdata2006n. Tom Lane 2006-11-01 05:20:38 +00:00
  • bf028fa8a6 Add description of new features Teodor Sigaev 2006-10-31 16:23:05 +00:00
  • 7e63445d59 Fix misstatement about the results of using -1 with BEGIN. Tom Lane 2006-10-31 02:29:15 +00:00
  • bc4b856e7b Add text to the VACUUM, REINDEX, DROP TABLESPACE and CREATE TABLESPACE reference pages documenting that these commands cannot be used within a transaction block. Also make some minor improvements to the psql reference page. Patch from Simon Riggs, minor editorialization by myself. Neil Conway 2006-10-31 01:52:31 +00:00
  • 0b9f93e6b0 Code the unknown options check without using m4 diversions. Otherwise this code relies on the checking macro actually being called at the end, or the automatic undiversion will produce garbage. These sort of implicit side-effects undermine the modularity of the macros and happen to break the ODBC driver which makes use of them. Peter Eisentraut 2006-10-30 22:15:04 +00:00
  • e45edb35e1 Fix typo in backup docs. Patch from Euler Taveira de Oliveira. Neil Conway 2006-10-30 00:08:02 +00:00
  • 27163e3872 Fix typo in docs. Bruce Momjian 2006-10-27 12:40:26 +00:00
  • 50f479a112 Fix spelling mistake in docs. Bruce Momjian 2006-10-26 17:07:03 +00:00
  • 75f0655345 Add missing file for documentation section on failover, replication, load balancing, and clustering options. Bruce Momjian 2006-10-26 15:32:45 +00:00
  • 2cbdb5522b Add documentation section on failover, replication, load balancing, and clustering options. Bruce Momjian 2006-10-26 15:26:54 +00:00
  • 76d5f6f035 expression_tree_walker failed to let walker function see the immediate child node of a SubLink or SubPlan testexpr field. Bug resulted from replacing the old lefthand/exprs list fields with a simple expression field, and not remembering that expression_tree_walker is coded to save a few cycles by recursing directly to self on list fields (on the assumption the walker isn't interested in List nodes per se). On non-list fields it must of course call the walker. Possibly that hack isn't worth the risk of more such bugs, but I'll leave it be for now. Per bug report from James Robinson. Tom Lane 2006-10-25 22:11:32 +00:00
  • 4df8de7a68 Fix check for whether a clauseless join has to be forced in the presence of outer joins. Originally it was only looking for overlap of the righthand side of a left join, but we have to do it on the lefthand side too. Per example from Jean-Pierre Pelletier. Tom Lane 2006-10-24 17:50:22 +00:00
  • d8221dfa6d Tweak zic.c to compile cleanly on MSVC: use CopyFile instead of CopyFileEx. This avoids a warning about the function not being present on older Windows versions. Magnus Hagander Tom Lane 2006-10-24 15:11:03 +00:00
  • 9601745d35 Correctino, add URL on : Bruce Momjian 2006-10-24 02:42:34 +00:00
  • 2b1ccefe72 Add URL for: Bruce Momjian 2006-10-24 02:41:22 +00:00
  • cfb3a42831 Rewrite discussion of ORDER BY to emphasize the SQL99 expression case instead of the SQL92 output-column-ID case. Tom Lane 2006-10-24 02:24:27 +00:00
  • 66f5264a2e Stamp 8.2beta2. REL8_2_BETA2 Tom Lane 2006-10-23 22:50:20 +00:00
  • 0ff4352d7a Add some real descriptions to the multiargument aggregate functions rather than just showing the incomprehensible formulas. Peter Eisentraut 2006-10-23 19:57:37 +00:00
  • 28b14b034a Fix broken markup. Tom Lane 2006-10-23 19:29:46 +00:00
  • 0f763503ff Spellchecking and such Peter Eisentraut 2006-10-23 18:10:32 +00:00
  • 033cb9d30b Fix list of environment variables for configure. Remove some variables that are almost never used. Put documentation-related variables into the documentation chapter. Peter Eisentraut 2006-10-23 14:13:43 +00:00
  • a09f9ff649 Small parser sync Michael Meskes 2006-10-23 08:00:48 +00:00
  • 954c1813ac Remove an unnecessary HOLD_INTERRUPTS/RESUME_INTERRUPTS pair. This was required back when RESUME_INTERRUPTS could actually execute ProcessInterrupts, but that hasn't been true since 2001... Tom Lane 2006-10-22 20:34:54 +00:00
  • bd95c74985 Code cleanup for pg_buffercache, from Mark Kirkwood. Tom Lane 2006-10-22 17:49:21 +00:00
  • c2c0b14086 Various MSVC build fixes from Magnus; also remove stray Windows newlines. Tom Lane 2006-10-22 17:17:09 +00:00
  • fa5d08fbf8 Some desultory copy-editing. Tom Lane 2006-10-22 03:03:41 +00:00
  • ed19393326 Some marginal editorial improvements and updates in the tutorial. Tom Lane 2006-10-21 23:12:57 +00:00
  • 9c2c41646a Translations update Peter Eisentraut 2006-10-21 21:03:04 +00:00
  • 890ce3975e Further release-note editorialization. Tom Lane 2006-10-21 18:41:53 +00:00
  • 425417d498 Editorial improvements for recent plpython doc updates. Tom Lane 2006-10-21 18:33:05 +00:00
  • 90f53d8487 Update PQserverVersion() to use 8.1.X as an example, rather than 7.4 because the function didn't exist in 7.4.X. Bruce Momjian 2006-10-21 18:25:01 +00:00
  • a7701718b2 Update release notes for new pgcrypto additions. Bruce Momjian 2006-10-21 18:15:44 +00:00
  • 944c4e3feb Add URL for async I/O: Bruce Momjian 2006-10-21 17:31:18 +00:00
  • a003bd07f3 Rewrite discussion of string constant syntax to bring it into line with the politically correct view that backslash escapes are deprecated. Tom Lane 2006-10-21 17:12:07 +00:00
  • c9c1c4edf2 Make index entry more specific. Tom Lane 2006-10-21 17:10:43 +00:00
  • a5007d671a pgbench: More fix with handling default scaling factor in the default scenarios. With multiple clinets, only the first client got the right scaling factor and this gave a illusion of better performance in case of the scaling factor greater than 1. Tatsuo Ishii 2006-10-21 06:31:28 +00:00
  • 554032b3e4 Update release notes to current, and do a pass of editorial corrections. Tom Lane 2006-10-20 23:02:20 +00:00
  • 8b175c75a8 Minor doc tweak: make a reference to pg_locks into a link. Neil Conway 2006-10-20 20:35:13 +00:00
  • b0b9bedf8d Fix typo. Alvaro Herrera 2006-10-20 16:34:48 +00:00
  • c4c0082262 Back-patch second version of AIX getaddrinfo fix. Tom Lane 2006-10-20 01:10:40 +00:00
  • 3aba3aa5b4 Back-patch second version of AIX getaddrinfo fix. Tom Lane 2006-10-20 01:10:35 +00:00
  • 8a6ed093b4 Back-patch second version of AIX getaddrinfo fix. Tom Lane 2006-10-20 01:10:28 +00:00
  • 7feedda098 Marginal code cleanups in pg_logdir_ls: use ReadDir not readdir, and avoid scribbling on its result (might be safe but why risk it) Tom Lane 2006-10-20 00:59:03 +00:00
  • 33af087695 Try to fix the AIX getaddrinfo mess in a way that works on all versions. Going to wait for buildfarm results before backpatching, this time. Tom Lane 2006-10-19 23:17:39 +00:00
  • 0549ba82e3 Clarify note about interaction of log_statement logging with errors. Remove obsolete note about logging of statements generated by plpgsql function execution ... that doesn't happen anymore. Tom Lane 2006-10-19 22:55:25 +00:00
  • 1b84441a49 Marginal improvement in logging: include the function name when logging a fastpath function call. Tom Lane 2006-10-19 22:44:11 +00:00
  • 4887f5f979 Rename our substitute qsort to pg_qsort at the link-symbol level (but provide a macro so code can still just say qsort). Avoids linker warnings on pickier platforms such as Darwin, and outright failure on MSVC. Tom Lane 2006-10-19 20:56:22 +00:00
  • 443abd83e5 Add externs for optarg/optind where apparently needed. Per Magnus. Tom Lane 2006-10-19 20:38:48 +00:00