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

Commit Graph

  • 0a646e801c Update catalog version for ltree changes. Bruce Momjian 2006-04-26 18:30:10 +00:00
  • b3e4aefcfb Enhanced containment selectivity function for /contrib/ltree Bruce Momjian 2006-04-26 18:28:34 +00:00
  • 0df32e3cbe Allow pg_resetxlog -f to reset pg_control counters using xlog information, and add a -r option to reset pg_control without affecting xlog. Bruce Momjian 2006-04-26 02:17:15 +00:00
  • 3289a932a9 Done: Bruce Momjian 2006-04-26 02:15:20 +00:00
  • abee2cdb1e Revise large-object access routines to avoid running with CurrentMemoryContext set to the large object context ("fscxt"), as this is inevitably a source of transaction-duration memory leaks. Not sure why we'd not noticed it before; maybe people weren't touching a whole lot of LOs in the same transaction before the 8.1 pg_dump changes. Per report from Wayne Conrad. Tom Lane 2006-04-26 00:35:35 +00:00
  • 486f994be7 Revise large-object access routines to avoid running with CurrentMemoryContext set to the large object context ("fscxt"), as this is inevitably a source of transaction-duration memory leaks. Not sure why we'd not noticed it before; maybe people weren't touching a whole lot of LOs in the same transaction before the 8.1 pg_dump changes. Per report from Wayne Conrad. Tom Lane 2006-04-26 00:34:57 +00:00
  • d2896a9ed1 Arrange to cache btree metapage data in the relcache entry for the index, thereby saving a visit to the metapage in most index searches/updates. This wouldn't actually save any I/O (since in the old regime the metapage generally stayed in cache anyway), but it does provide a useful decrease in bufmgr traffic in high-contention scenarios. Per my recent proposal. Tom Lane 2006-04-25 22:46:05 +00:00
  • 89083876c9 Adjust SGML spacing. Bruce Momjian 2006-04-25 21:02:33 +00:00
  • 7e2d5594d7 Back out the rest of the RESET CONNECTION patch. Tom Lane 2006-04-25 18:58:37 +00:00
  • 4454eead14 The 8.1 planner removes WHERE quals from the plan when the quals are implied by the predicate of a partial index being used to scan a table. However, this optimization is unsafe in an UPDATE, DELETE, or SELECT FOR UPDATE query, because the quals need to be rechecked by EvalPlanQual if there's an update conflict. Per example from Jean-Samuel Reynaud. Tom Lane 2006-04-25 16:54:26 +00:00
  • 1e3593ce16 The 8.1 planner removes WHERE quals from the plan when the quals are implied by the predicate of a partial index being used to scan a table. However, this optimization is unsafe in an UPDATE, DELETE, or SELECT FOR UPDATE query, because the quals need to be rechecked by EvalPlanQual if there's an update conflict. Per example from Jean-Samuel Reynaud. Tom Lane 2006-04-25 16:54:09 +00:00
  • ff49a020ca Remove equals sign from environment variable with not defaults for configure. Bruce Momjian 2006-04-25 15:19:16 +00:00
  • 1bd8f4f54f Make configure environment variable options without defaults not have an equals sign. Bruce Momjian 2006-04-25 15:17:04 +00:00
  • 67248f7290 Add documentation about configure environment variabbles used. Bruce Momjian 2006-04-25 15:14:16 +00:00
  • 706cbfd632 Call SET varaiables "configuration_parameter"s in the documentation. Bruce Momjian 2006-04-25 14:56:04 +00:00
  • e72fd16fa8 Change "parameter" to "varname" in the alter role and alter user documentation sections. Also update SET/RESET to be consistent. Bruce Momjian 2006-04-25 14:47:29 +00:00
  • 5fd7df43e2 I now see we support RESET SESSION AUTHORIZATION, so it seems we have to use RESET CONNECTION: Bruce Momjian 2006-04-25 14:33:41 +00:00
  • 2b70093548 RESET SESSION is more precise: Bruce Momjian 2006-04-25 14:31:03 +00:00
  • 59d591e79a Back out RESET CONNECTION until there is more discussion. Bruce Momjian 2006-04-25 14:11:59 +00:00
  • 6378fdd971 Add RESET CONNECTION, to reset all aspects of a session. Bruce Momjian 2006-04-25 14:09:21 +00:00
  • 11fbdf2f25 Update inheritance constraint items: Bruce Momjian 2006-04-25 02:58:34 +00:00
  • a34fd95977 Fix bug reported by Michael Fuhr on Sun, 23 Apr 2006 09:52:31 -0600 (pgsql-committers@postgresql.org). Tatsuo Ishii 2006-04-25 00:40:54 +00:00
  • b532c86f2e Done: Bruce Momjian 2006-04-25 00:26:53 +00:00
  • e6004f0151 Add statement_timestamp(), clock_timestamp(), and transaction_timestamp() (just like now()). Bruce Momjian 2006-04-25 00:25:22 +00:00
  • f04080d73b Word wrap entry Bruce Momjian 2006-04-25 00:06:23 +00:00
  • c880f9aeb2 Update SQL-standard INTERVAL item: Bruce Momjian 2006-04-25 00:01:44 +00:00
  • 02b59c6ebd Done; Bruce Momjian 2006-04-24 22:59:46 +00:00
  • cd48ae8bf0 Back out patch, unintended. Bruce Momjian 2006-04-24 22:59:19 +00:00
  • ec9d01e8e2 Done: Bruce Momjian 2006-04-24 22:56:11 +00:00
  • 5bbea03f3b Suppress more compiler warnings caused by macro tests. Bruce Momjian 2006-04-24 22:24:58 +00:00
  • 7384e95b0c Add one more paren to macro. Bruce Momjian 2006-04-24 22:17:04 +00:00
  • 88fc941355 Suprress compiler warning in gcc 4.2. Bruce Momjian 2006-04-24 22:06:32 +00:00
  • 2c4abf11e1 Improve our private implementation of cbrt() to give results of the accuracy expected by the regression tests. Per suggestion from Martijn van Oosterhout. Tom Lane 2006-04-24 20:36:41 +00:00
  • 332ea60d23 Improve our private implementation of cbrt() to give results of the accuracy expected by the regression tests. Per suggestion from Martijn van Oosterhout. Tom Lane 2006-04-24 20:36:32 +00:00
  • 7e97b419df Remove compiler warning by casting SNPRINTF() call to void. Bruce Momjian 2006-04-24 19:51:13 +00:00
  • 1d18949563 Fixed memory leak bugs found by Martijn Oosterhout. Michael Meskes 2006-04-24 09:46:32 +00:00
  • 46942e84d9 Fixed memory leak bugs found by Martijn Oosterhout. Michael Meskes 2006-04-24 09:45:57 +00:00
  • e37c0d2eb8 Fixed memory leak bugs found by Martijn Oosterhout. Michael Meskes 2006-04-24 09:45:44 +00:00
  • 524d65d459 Fixed memory leak bugs found by Martijn Oosterhout. Michael Meskes 2006-04-24 09:45:22 +00:00
  • 499ec8c7e4 Fixes for BCC 5.5 compile of libpq. Backpatch to 8.1.X. Bruce Momjian 2006-04-24 04:03:42 +00:00
  • a16ffee73b Fixes for BCC 5.5 compile of libpq. Backpatch to 8.1.X. Bruce Momjian 2006-04-24 04:03:25 +00:00
  • 732a1fd1d0 Don't add a shared dependency on the owner of a composite type in pg_class. We track the owner in pg_type instead, as that is the place where the owner is changed on ALTER TYPE ... OWNER TO. Alvaro Herrera 2006-04-24 01:40:48 +00:00
  • 7f0c9716ba Don't add a shared dependency on the owner of a composite type in pg_class. We track the owner in pg_type instead, as that is the place where the owner is changed on ALTER TYPE ... OWNER TO. Alvaro Herrera 2006-04-24 01:40:39 +00:00
  • 109d0aeb11 Add: Bruce Momjian 2006-04-23 04:00:06 +00:00
  • efe3de07e9 Removes or minimizes some documentation mentions of backward compatibility for release 7.2 and earlier. I have not altered any mentions of release 7.3 or later. The release notes were not modified, so the changes are still documented, just not in the main docs. Bruce Momjian 2006-04-23 03:39:52 +00:00
  • 4799cd7f24 Add pgrowlocks Tatsuo Ishii 2006-04-23 02:17:59 +00:00
  • 66126f9687 Add new contrib function pgrowlocks. See README.pgrowlocks for more details. Tatsuo Ishii 2006-04-23 01:12:58 +00:00
  • 044c3b4615 Update: Bruce Momjian 2006-04-22 18:18:24 +00:00
  • 11c4152919 Update: Bruce Momjian 2006-04-22 18:17:57 +00:00
  • 0a66e482a7 Update: Bruce Momjian 2006-04-22 16:06:44 +00:00
  • 21138b5e59 Suggest Win32 users user E'' strings and double backslashes used for patch separators in COPY. Bruce Momjian 2006-04-22 03:03:19 +00:00
  • 9d483b7bcf Suggest Win32 users user E'' strings and double backslashes used for patch separators in COPY. Bruce Momjian 2006-04-22 03:03:11 +00:00
  • 2206b498d8 Simplify ParamListInfo data structure to support only numbered parameters, not named ones, and replace linear searches of the list with array indexing. The named-parameter support has been dead code for many years anyway, and recent profiling suggests that the searching was costing a noticeable amount of performance for complex queries. Tom Lane 2006-04-22 01:26:01 +00:00
  • 0606860a20 Revert Intel compiler bug comment. Bruce Momjian 2006-04-22 00:29:41 +00:00
  • 4e0783049d Add mentioun of Intel compiler bug: Bruce Momjian 2006-04-22 00:27:30 +00:00
  • 899f49cfce Use special gcc -W flags only if we are using gcc, not if we are using the Intel compiler. Bruce Momjian 2006-04-21 23:11:58 +00:00
  • 1b4504ced2 Remove from TODO ability to edit pg_hba.conf, but add GRANT connection permission item: Bruce Momjian 2006-04-21 20:46:22 +00:00
  • b5498a26de Add some optional code (conditionally compiled under #ifdef LWLOCK_STATS) to track the number of LWLock acquisitions and the number of times we block waiting for an LWLock, on a per-process basis. After having needed this twice in the past few months, seems like it should go into CVS. Tom Lane 2006-04-21 16:45:12 +00:00
  • efe222268f Eliminate some no-longer-needed workarounds for palloc's old behavior of rejecting palloc(0). Also, tweak like_selectivity() to avoid assuming the presented pattern is nonempty; although that assumption is valid, it doesn't really help much, and the new coding is more correct anyway since it properly handles redundant wildcards. In combination these changes should eliminate a Coverity warning noted by Martijn. Tom Lane 2006-04-20 17:50:18 +00:00
  • ea6d54ee06 Add "retry another address" log message on statistics collector socket failure, to reduce confusion in the log file. Bruce Momjian 2006-04-20 10:51:32 +00:00
  • eac825aa68 Ensure that we validate the page header of the first page of a WAL file whenever we start to read within that file. The first page carries extra identification information that really ought to be checked, but as the code stood, this was only checked when we switched sequentially into a new WAL file, or if by chance the starting checkpoint record was within the first page. This patch ensures that we will detect bogus 'long header' information before we start replaying the WAL sequence. Tom Lane 2006-04-20 04:07:38 +00:00
  • cc7eab38dd Recognize __ppc64__, which seems to be Apple's spelling of the predefined symbol for PPC64 hardware. I hadn't known that Apple supported PPC64 at all, but darn if there aren't 64-bit variant libraries in OS X as well as support in their gcc. Tom Lane 2006-04-19 23:11:15 +00:00
  • 19fe9a904a Add detail: Bruce Momjian 2006-04-19 22:35:42 +00:00
  • ce8c6aa76c Add: Bruce Momjian 2006-04-19 21:50:19 +00:00
  • 5d096d0127 Fix problem that sscanf(buf, "%d", &val) eats leading white space, but our to_* functions were not handling that. Bruce Momjian 2006-04-19 18:49:09 +00:00
  • 04ca4caa81 Remove use of lorder and tsort while building static libraries. There's no evidence that any currently-supported platform needs this, and good reason to think that any platform that did need it couldn't use the static libraries anyway --- libpq, at least, has circular references. Removing the code shuts up tsort warnings about the circular references on some platforms. Tom Lane 2006-04-19 16:32:08 +00:00
  • 803d61a353 Fix ancient memory leak in PQprintTuples(); our code no longer uses this routine, but perhaps some applications do. Found by Martijn van Oosterhout using Coverity. Tom Lane 2006-04-19 16:16:08 +00:00
  • 8a3789cdfa Fix ancient memory leak in PQprintTuples(); our code no longer uses this routine, but perhaps some applications do. Found by Martijn van Oosterhout using Coverity. Tom Lane 2006-04-19 16:15:52 +00:00
  • 8f7fce2fd6 Fix ancient memory leak in PQprintTuples(); our code no longer uses this routine, but perhaps some applications do. Found by Martijn van Oosterhout using Coverity. Tom Lane 2006-04-19 16:15:41 +00:00
  • bc5ba26d6b Fix ancient memory leak in PQprintTuples(); our code no longer uses this routine, but perhaps some applications do. Found by Martijn van Oosterhout using Coverity. Tom Lane 2006-04-19 16:15:34 +00:00
  • 8f52496a05 Fix ancient memory leak in PQprintTuples(); our code no longer uses this routine, but perhaps some applications do. Found by Martijn van Oosterhout using Coverity. Tom Lane 2006-04-19 16:15:29 +00:00
  • 3224f2ee25 Fix a couple of rather-pointless-but-easily-fixed Coverity warnings. Per Martijn van Oosterhout. Tom Lane 2006-04-19 16:02:17 +00:00
  • e37a649e94 C code whitespace inprovement for formatting.c. Bruce Momjian 2006-04-19 14:48:06 +00:00
  • b3e4a84ba5 Add: Bruce Momjian 2006-04-19 02:46:32 +00:00
  • af86aa8443 Remove kill mention in install docs, was for pre-7.0 releases. Bruce Momjian 2006-04-18 22:52:07 +00:00
  • 6b46ec2707 Mention "syntax" error as not logged by log_statement. Backpatch. Bruce Momjian 2006-04-18 12:41:29 +00:00
  • f57b2f09a8 Mention "syntax" error as not logged by log_statement. Backpatch. Bruce Momjian 2006-04-18 12:41:15 +00:00
  • 65f1a7a8dc Document that errors are not output by log_statement (was they were in 8.0), and add as suggestion to use log_min_error_statement for this purpose. I also fixed the code so the first EXECUTE has it's prepare, rather than the last which is what was in the current code. Also remove "protocol" prefix for SQL EXECUTE output because it is not accurate. Bruce Momjian 2006-04-18 00:52:41 +00:00
  • 5bd59b9c0a Document that errors are not output by log_statement (was they were in 8.0), and add as suggestion to use log_min_error_statement for this purpose. I also fixed the code so the first EXECUTE has it's prepare, rather than the last which is what was in the current code. Also remove "protocol" prefix for SQL EXECUTE output because it is not accurate. Bruce Momjian 2006-04-18 00:52:23 +00:00
  • 0a87394956 Fix the torn-page hazard for PITR base backups by forcing full page writes to occur between pg_start_backup() and pg_stop_backup(), even if the GUC setting full_page_writes is OFF. Per discussion, doing this in combination with the already-existing checkpoint during pg_start_backup() should ensure safety against partial page updates being included in the backup. We do not have to force full page writes to occur during normal PITR operation, as I had first feared. Tom Lane 2006-04-17 18:55:05 +00:00
  • 8e7aaeb62e Done: Bruce Momjian 2006-04-17 03:18:07 +00:00
  • 922f7536c9 Remove: Bruce Momjian 2006-04-15 18:13:11 +00:00
  • dd8d1b1fbd Document that pg_dump -d/-D prevents invalid data from canceling the entire table load. Bruce Momjian 2006-04-15 18:11:48 +00:00
  • 598dfee552 Document that pg_dump -d/-D prevents invalid data from canceling the entire table load. Bruce Momjian 2006-04-15 18:11:16 +00:00
  • 3651a3e6fb Support the syntax CREATE AGGREGATE aggname (input_type) (parameter_list) along with the old syntax where the input type was named in the parameter list. This fits more naturally with the way that the aggregate is identified in DROP AGGREGATE and other utility commands; furthermore it has a natural extension to handle multiple-input aggregates, where the basetype-parameter method would get ugly. In fact, this commit fixes the grammar and all the utility commands to support multiple-input aggregates; but DefineAggregate rejects it because the executor isn't fixed yet. I didn't do anything about treating agg(*) as a zero-input aggregate instead of artificially making it a one-input aggregate, but that should be considered in combination with supporting multi-input aggregates. Tom Lane 2006-04-15 17:45:46 +00:00
  • ebd5257d49 Done: Bruce Momjian 2006-04-14 22:26:22 +00:00
  • defe93463c Make the world safe for full_page_writes. Allow XLOG records that try to update no-longer-existing pages to fall through as no-ops, but make a note of each page number referenced by such records. If we don't see a later XLOG entry dropping the table or truncating away the page, complain at the end of XLOG replay. Since this fixes the known failure mode for full_page_writes = off, revert my previous band-aid patch that disabled that GUC variable. Tom Lane 2006-04-14 20:27:24 +00:00
  • 0fcc3c2f1d Repair a low-probability race condition identified by Qingqing Zhou. If a process abandons a wait in LockBufferForCleanup (in practice, only happens if someone cancels a VACUUM) just before someone else sends it a signal indicating the buffer is available, it was possible for the wakeup to remain in the process' semaphore, causing misbehavior next time the process waited for an lmgr lock. Rather than try to prevent the race condition directly, it seems best to make the lock manager robust against leftover wakeups, by having it repeat waiting on the semaphore if the lock has not actually been granted or denied yet. Tom Lane 2006-04-14 03:38:56 +00:00
  • e1b40c521e Fix similar_escape() so that SIMILAR TO works properly for patterns involving alternatives ("|" symbol). The original coding allowed the added ^ and $ constraints to be absorbed into the first and last alternatives, producing a pattern that would match more than it should. Per report from Eric Noriega. Tom Lane 2006-04-13 18:01:53 +00:00
  • f8511d4cc9 Fix similar_escape() so that SIMILAR TO works properly for patterns involving alternatives ("|" symbol). The original coding allowed the added ^ and $ constraints to be absorbed into the first and last alternatives, producing a pattern that would match more than it should. Per report from Eric Noriega. Tom Lane 2006-04-13 18:01:45 +00:00
  • d17c5f0acc Fix similar_escape() so that SIMILAR TO works properly for patterns involving alternatives ("|" symbol). The original coding allowed the added ^ and $ constraints to be absorbed into the first and last alternatives, producing a pattern that would match more than it should. Per report from Eric Noriega. Tom Lane 2006-04-13 18:01:38 +00:00
  • cc39aca7d4 Fix similar_escape() so that SIMILAR TO works properly for patterns involving alternatives ("|" symbol). The original coding allowed the added ^ and $ constraints to be absorbed into the first and last alternatives, producing a pattern that would match more than it should. Per report from Eric Noriega. Tom Lane 2006-04-13 18:01:31 +00:00
  • dcdf738abb Fix HTML markup. Bruce Momjian 2006-04-13 12:20:36 +00:00
  • 2aca4e84af Update tutorial URL's. Bruce Momjian 2006-04-13 12:14:41 +00:00
  • 452b2fc6e4 Update URL for SQL tutorial. Bruce Momjian 2006-04-13 12:09:08 +00:00
  • 9b83454f7f Update AIX FAQ: Bruce Momjian 2006-04-13 11:42:35 +00:00
  • 98c6c966bc Update AIX FAQ: Bruce Momjian 2006-04-13 11:41:02 +00:00
  • 9204980aa1 Update: Bruce Momjian 2006-04-13 10:50:13 +00:00
  • 49a7610c36 Fix an ancient oversight in btree xlog replay. When trying to determine if an upper-level insertion completes a previously-seen split, we cannot simply grab the downlink block number out of the buffer, because the buffer could contain a later state of the page --- or perhaps the page doesn't even exist at all any more, due to relation truncation. These possibilities have been masked up to now because the use of full_page_writes effectively ensured that no xlog replay routine ever actually saw a page state newer than its own change. Since we're deprecating full_page_writes in 8.1.*, there's no need to fix this in existing release branches, but we need a fix in HEAD if we want to have any hope of re-allowing full_page_writes. Accordingly, adjust the contents of btree WAL records so that we can always get the downlink block number from the WAL record rather than having to depend on buffer contents. Per report from Kevin Grittner and Peter Brant. Tom Lane 2006-04-13 03:53:05 +00:00
  • e4b8253c40 Fix pg_restore -n option to do what the man page says it does. The original coding only worked if one of the selTypes restriction options was also given. Per report from Nick Johnson. Tom Lane 2006-04-12 22:19:01 +00:00