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

Commit Graph

  • d5b98e4ce0 Clarify item: Bruce Momjian 2005-02-21 04:58:52 +00:00
  • 99bf6a1634 Updates to the bibliography. Patch from Michael Fuhr. Neil Conway 2005-02-21 02:21:03 +00:00
  • abd7168524 Document the "register" and "unregister" pg_ctl subcommands, for use on Windows. Patch from Magnus Hagander. Neil Conway 2005-02-21 02:14:34 +00:00
  • f18752dab5 Document the "register" and "unregister" pg_ctl subcommands, for use on Windows. Patch from Magnus Hagander. Neil Conway 2005-02-21 02:13:26 +00:00
  • bb0aed591f Use SnapshotNow instead of SnapshotSelf for reading the catalogs during flat-file writing. The only difference is that SnapshotSelf would consider tuples of the 'current command' within the current transaction as valid, where SnapshotNow wouldn't. We can eliminate the need for this with one extra CommandCounterIncrement call before we start reading the catalogs. Tom Lane 2005-02-20 22:02:19 +00:00
  • 4aefe75553 Remove some no-longer-needed kluges for bootstrapping, in particular the AMI_OVERRIDE flag. The fact that TransactionLogFetch treats BootstrapTransactionId as always committed is sufficient to make bootstrap work, and getting rid of extra tests in heavily used code paths seems like a win. The files produced by initdb are demonstrably the same after this change. Tom Lane 2005-02-20 21:46:50 +00:00
  • 57e3b0c9db Rename macro to MAKE_EXPIRED_TUPLES_VISIBLE. Bruce Momjian 2005-02-20 15:01:42 +00:00
  • f6a7bef915 Fix MAKE_ALL_TUPLES_VISIBLE define. Bruce Momjian 2005-02-20 15:00:16 +00:00
  • 5845bfb8bf Move define MAKE_ALL_TUPLES_VISIBLE to a more logical place. Bruce Momjian 2005-02-20 14:57:47 +00:00
  • 59191b2245 I have added a define, MAKE_ALL_TUPLES_VISIBLE, to help people recover deleted tuples. Of course it is only to be used for disaster recovery. Bruce Momjian 2005-02-20 04:56:00 +00:00
  • 3f9aec50e7 Flat file cleanup phase 2: make it work for pg_group. The flat group file now identifies group members by usesysid not name; this avoids needing to depend on SearchSysCache which we can't use during startup. (The old representation was entirely broken anyway, since we did not regenerate the file following RENAME USER.) It's only a 95% solution because if the group membership list is big enough to be toasted out of line, we cannot read it during startup. I think this will do for the moment, until we have time to implement the planned pg_role replacement for pg_group. Tom Lane 2005-02-20 04:45:59 +00:00
  • 60b2444cc3 Add code to prevent transaction ID wraparound by enforcing a safe limit in GetNewTransactionId(). Since the limit value has to be computed before we run any real transactions, this requires adding code to database startup to scan pg_database and determine the oldest datfrozenxid. This can conveniently be combined with the first stage of an attack on the problem that the 'flat file' copies of pg_shadow and pg_group are not properly updated during WAL recovery. The code I've added to startup resides in a new file src/backend/utils/init/flatfiles.c, and it is responsible for rewriting the flat files as well as initializing the XID wraparound limit value. This will eventually allow us to get rid of GetRawDatabaseInfo too, but we'll need an initdb so we can add a trigger to pg_database. Tom Lane 2005-02-20 02:22:07 +00:00
  • 0845ee3958 New arrangement to always let the bgwriter do checkpoints broke CHECKPOINT and some other commands in the context of a standalone backend. Allow a standalone backend to do its own checkpoints. Tom Lane 2005-02-19 23:16:27 +00:00
  • 617d16f4ff New arrangement to always let the bgwriter do checkpoints broke CHECKPOINT and some other commands in the context of a standalone backend. Allow a standalone backend to do its own checkpoints. Tom Lane 2005-02-19 23:16:15 +00:00
  • 2df2c3dca2 Ensure that the resolved datatype of any unknown Param is propagated into the sub-SELECT targetlist when it appears in the context INSERT INTO foo SELECT $1 ... Per report from Abhijit Menon-Sen. Tom Lane 2005-02-19 19:33:42 +00:00
  • 254eef2f28 Ensure that the resolved datatype of any unknown Param is propagated into the sub-SELECT targetlist when it appears in the context INSERT INTO foo SELECT $1 ... Per report from Abhijit Menon-Sen. Tom Lane 2005-02-19 19:33:23 +00:00
  • 9650d6c7e6 Ensure that the resolved datatype of any unknown Param is propagated into the sub-SELECT targetlist when it appears in the context INSERT INTO foo SELECT $1 ... Per report from Abhijit Menon-Sen. Tom Lane 2005-02-19 19:33:08 +00:00
  • 2abe40aac7 Fix typo in SGML. Bruce Momjian 2005-02-19 04:39:52 +00:00
  • eea1ef2c85 Add reference to the NewbieDoc Docbook Guide. Bruce Momjian 2005-02-19 04:34:17 +00:00
  • a8593a3463 Convert MemoryContextSwitchTo() into an inline function when using GCC. Tom Lane 2005-02-18 21:52:34 +00:00
  • 477a64d9c8 Update question text: Bruce Momjian 2005-02-15 04:35:37 +00:00
  • a284e174a3 Update Momjain book URL. Bruce Momjian 2005-02-15 04:03:46 +00:00
  • f58918ecd0 Update URL for Momjian book. Bruce Momjian 2005-02-15 04:02:25 +00:00
  • bb8fcd6713 Change wording: Bruce Momjian 2005-02-15 03:54:19 +00:00
  • 50263789d6 Add mention of syntax for GRANT ALL: Bruce Momjian 2005-02-15 03:53:00 +00:00
  • 3110cd237c Update comment on VACUUM FULL. Bruce Momjian 2005-02-15 03:50:07 +00:00
  • b39ce1ccec Fix typo: Bruce Momjian 2005-02-15 03:17:41 +00:00
  • 43410176a8 Add: Bruce Momjian 2005-02-15 02:27:36 +00:00
  • 1d7dfb1496 Document usage of gettext_noop(). Bruce Momjian 2005-02-15 01:03:47 +00:00
  • d73e0410bd Improve documentation of signal usage for HAVE_SIGPROCMASK and non-HAVE_SIGPROCMASK cases in pqinitmask(). Bruce Momjian 2005-02-14 23:02:35 +00:00
  • ad4f06aeb2 Improve documentation of signal usage for HAVE_SIGPROCMASK and non-HAVE_SIGPROCMASK cases in pqinitmask(). Bruce Momjian 2005-02-14 23:02:03 +00:00
  • b25bb4fd44 Add: Bruce Momjian 2005-02-14 19:51:17 +00:00
  • 42e386f257 ALTER LANGUAGE RENAME has never worked. Per Sergey Yatskevich. Tom Lane 2005-02-14 06:18:09 +00:00
  • c35c944b87 ALTER LANGUAGE RENAME has never worked. Per Sergey Yatskevich. Tom Lane 2005-02-14 06:17:59 +00:00
  • db58ee5be9 ALTER LANGUAGE RENAME has never worked. Per Sergey Yatskevich. Tom Lane 2005-02-14 06:17:44 +00:00
  • 73f5c9d90e Minor consistency improvement. Neil Conway 2005-02-14 00:54:26 +00:00
  • f25df821a9 Add: Bruce Momjian 2005-02-14 00:03:57 +00:00
  • 92597d1386 Print file name and errno string on rmtree failure. Bruce Momjian 2005-02-13 16:50:54 +00:00
  • bb17a98e3c Print file name and errno string on rmtree failure. Bruce Momjian 2005-02-13 16:50:44 +00:00
  • c6521b1b93 Write some real documentation about the index access method API. Tom Lane 2005-02-13 03:04:15 +00:00
  • 67ff8009cf Move plpgsql DEBUG from DEBUG2 to DEBUG1 because it is a user-requested DEBUG. Bruce Momjian 2005-02-13 01:25:50 +00:00
  • 5e73d4361c Clarify: Bruce Momjian 2005-02-13 00:10:41 +00:00
  • 6370007ce8 Add: Bruce Momjian 2005-02-13 00:09:34 +00:00
  • 7c44e57331 Move plpgsql DEBUG from DEBUG2 to DEBUG1 because it is a user-requested DEBUG. Bruce Momjian 2005-02-12 23:53:42 +00:00
  • e9d693411c Add a regression test to verify that the stack depth checker actually works (and max_stack_depth is not set too high for the platform). Inspired by trouble report from Brian Betts. Tom Lane 2005-02-11 22:15:12 +00:00
  • 66b568ca96 Translation updates Peter Eisentraut 2005-02-11 11:53:32 +00:00
  • 8814ee8497 Update to Russian FAQ, HEAD and 8.0.X. Bruce Momjian 2005-02-11 04:54:05 +00:00
  • 49c320b19d Update to Russian FAQ, HEAD and 8.0.X. Bruce Momjian 2005-02-11 04:53:51 +00:00
  • 341251f202 Make clearer warning about using 'now' with DEFAULT: Bruce Momjian 2005-02-11 04:31:54 +00:00
  • 538e960939 Mention that some psql environment variables come from libpq and note more variables can be found in the libpq manual section. Bruce Momjian 2005-02-11 04:19:18 +00:00
  • 056a664fa1 Mention that some psql environment variables come from libpq and note more variables can be found in the libpq manual section. Bruce Momjian 2005-02-11 04:19:05 +00:00
  • 975e27377a Adjust input routines for float4, float8 and oid to reject the empty string as valid input (it was previously treated as 0). This input was deprecated in 8.0 (and a warning was emitted). Regression tests updated. Neil Conway 2005-02-11 04:09:05 +00:00
  • 4db84f0880 Fix ANALYZE to accumulate some minimal statistics for an all-null column. Per gripes from Mike Mascari and Bernd Heller. Tom Lane 2005-02-11 00:41:12 +00:00
  • 6d28a8fee9 Back-patch fix for a typo that unintentionally disabled backward scans for all SPI-created cursors. Tom Lane 2005-02-10 20:37:15 +00:00
  • 9843862b50 Fix SPI cursor support to allow scanning the results of utility commands that return tuples (such as EXPLAIN). Per gripe from Michael Fuhr. Side effect: fix an old bug that unintentionally disabled backward scans for all SPI-created cursors. Tom Lane 2005-02-10 20:36:49 +00:00
  • 42599b322d Fix SPI cursor support to allow scanning the results of utility commands that return tuples (such as EXPLAIN). Per gripe from Michael Fuhr. Side effect: fix an old bug that unintentionally disabled backward scans for all SPI-created cursors. Tom Lane 2005-02-10 20:36:28 +00:00
  • 5cc8884a5d Fixed changelog entry to list correct bug reporter. Michael Meskes 2005-02-10 08:08:52 +00:00
  • 95b40b7f77 Fixed more parsing bugs in other CREATE statements. Michael Meskes 2005-02-10 08:07:46 +00:00
  • 7e786a82ca Fixed more parsing bugs in other CREATE statements as pointed out by TANIDA Yutaka <tanida@sra.co.jp>. Michael Meskes 2005-02-10 08:06:35 +00:00
  • 35878b9bc6 Add some index entries for RAISE and exception handling in PL/PgSQL. Per suggestion from Rainer Brandt. Neil Conway 2005-02-10 06:08:22 +00:00
  • cf1f6f98f2 Improvements to documentation of shared memory configuration under FreeBSD. From Mark Kirkwood, editorializing by Neil Conway. Neil Conway 2005-02-10 05:14:58 +00:00
  • 280cae35aa Use now() rather than 'now' in an example in the PL/PgSQL docs. From David Fetter and Ben Calvert. Neil Conway 2005-02-10 05:01:07 +00:00
  • 7dfc700b96 Update pginstaller URL to http://www.postgresql.org/ftp/win32/. Bruce Momjian 2005-02-10 04:53:11 +00:00
  • 8f5b4c8c8c Update pginstaller URL to http://www.postgresql.org/ftp/win32/. Bruce Momjian 2005-02-10 04:52:31 +00:00
  • 789aafebd5 ALTER TABLE ADD COLUMN exhibits a significant memory leak when adding a column with a default expression. In that situation, we need to rewrite the heap relation. To evaluate the new default expression, we use ExecEvalExpr(); however, this can allocate memory in the current memory context, and ATRewriteTable() does not switch out of the active portal's heap memory context. The end result is a rather large memory leak (on the order of gigabytes for a reasonably sized table). Neil Conway 2005-02-09 23:27:24 +00:00
  • 3df9abd1a5 ALTER TABLE ADD COLUMN exhibits a significant memory leak when adding a column with a default expression. In that situation, we need to rewrite the heap relation. To evaluate the new default expression, we use ExecEvalExpr(); however, this can allocate memory in the current memory context, and ATRewriteTable() does not switch out of the active portal's heap memory context. The end result is a rather large memory leak (on the order of gigabytes for a reasonably sized table). Neil Conway 2005-02-09 23:17:26 +00:00
  • ef006ded8e Fixed bug in parsing of CREATE AS statement. Michael Meskes 2005-02-09 11:28:21 +00:00
  • d32b3aec52 Fixed bug in parsing of CREATE AS statement. Michael Meskes 2005-02-09 11:26:44 +00:00
  • 46ace73498 Back-patch Neil's four additional buffer overrun checks. Tom Lane 2005-02-08 18:22:54 +00:00
  • 013d778e32 Back-patch Neil's four additional buffer overrun checks. Tom Lane 2005-02-08 18:22:45 +00:00
  • d60b1f5689 If we're gonna check for array overrun, we really should do so before overrunning the array, not after. Tom Lane 2005-02-08 18:22:11 +00:00
  • ae50aa7ee8 If we're gonna check for array overrun, we really should do so before overrunning the array, not after. Tom Lane 2005-02-08 18:21:59 +00:00
  • 38efdc8bc1 Spacing: Bruce Momjian 2005-02-08 03:23:51 +00:00
  • dc95779679 It seems like most people don't want automatic failover so I am removing the item: Bruce Momjian 2005-02-08 03:21:02 +00:00
  • 5c057d4b44 Prevent 4 more buffer overruns in the PL/PgSQL parser. This is just a minimally-invasive fix for stable branches; a cleaner fix will be committed to HEAD soon. Neil Conway 2005-02-07 03:55:28 +00:00
  • 6c5c748d64 Prevent 4 more buffer overruns in the PL/PgSQL parser. This is just a minimally-invasive fix for stable branches; a cleaner fix will be committed to HEAD soon. Neil Conway 2005-02-07 03:52:22 +00:00
  • 5b327fb917 Better late than never: document that the GiST API changed in 8.0 in the "incompatibilities" section of the release notes. Neil Conway 2005-02-06 22:36:10 +00:00
  • c76ff4bc4e Better late than never: document that the GiST API changed in 8.0 in the "incompatibilities" section of the release notes. Neil Conway 2005-02-06 22:31:50 +00:00
  • c31570ed43 Document array behavior for out-of-range subscripts. Tom Lane 2005-02-06 20:59:37 +00:00
  • e507399790 Document array behavior for out-of-range subscripts. Tom Lane 2005-02-06 20:59:30 +00:00
  • 3f8235ba24 Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS. Turns out there are corner cases involving dropping toasted columns in which the previous coding would fail, too: the new version of the table might not have any TOAST table, but we'd still propagate possibly-wide values of dropped columns forward. Tom Lane 2005-02-06 20:19:42 +00:00
  • 0aeb7d8008 Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS. Turns out there are corner cases involving dropping toasted columns in which the previous coding would fail, too: the new version of the table might not have any TOAST table, but we'd still propagate possibly-wide values of dropped columns forward. Tom Lane 2005-02-06 20:19:24 +00:00
  • 2a6c032503 Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS. Turns out there are corner cases involving dropping toasted columns in which the previous coding would fail, too: the new version of the table might not have any TOAST table, but we'd still propagate possibly-wide values of dropped columns forward. Tom Lane 2005-02-06 20:19:08 +00:00
  • 5bb38455e6 Back-port heap_deformtuple() into 7.4 branch; needed for planned fix for CLUSTER failure after ALTER TABLE SET WITHOUT OIDS. Tom Lane 2005-02-06 20:15:32 +00:00
  • 4f82112473 Fix bit-rot in ipc_test.c; it didn't include some stuff that pg_shmem.c now depends on. Tom Lane 2005-02-05 20:07:16 +00:00
  • 12179c99b1 Marginal hack to merge adjacent ReleaseBuffer/ReadBuffer calls into ReleaseAndReadBuffer during GIST index searches. We already did this in btree and rtree, might as well do it here too. Tom Lane 2005-02-05 19:38:58 +00:00
  • 11635c3f6f Refactor some duplicated code in lock.c: create UnGrantLock(), move code from LockRelease() and LockReleaseAll() into it. From Heikki Linnakangas. Neil Conway 2005-02-04 02:04:53 +00:00
  • a7bbb6cd53 Fix minor thinko in logic to set dump order when dumping from a pre-7.3 database: aggregates should be dumped in the same pass as operators, not in the same pass as functions. Tom Lane 2005-02-03 23:39:21 +00:00
  • ee467c3530 Fix minor thinko in logic to set dump order when dumping from a pre-7.3 database: aggregates should be dumped in the same pass as operators, not in the same pass as functions. Tom Lane 2005-02-03 23:38:58 +00:00
  • c8460d571e Ensure that all details of the ARC algorithm are hidden within freelist.c. This refactoring does not change any algorithms or data structures, just remove visibility of the ARC datastructures from other source files. Tom Lane 2005-02-03 23:30:12 +00:00
  • cc4f58f4cd Ensure that all details of the ARC algorithm are hidden within freelist.c. This refactoring does not change any algorithms or data structures, just remove visibility of the ARC datastructures from other source files. Tom Lane 2005-02-03 23:29:19 +00:00
  • ad893a361d Minor SGML improvements. Neil Conway 2005-02-03 07:12:37 +00:00
  • f76390d75a Improve performance of fmgr.c calling routines for cases with more than two arguments. Per suggestions from A. Ogawa. Tom Lane 2005-02-02 22:40:19 +00:00
  • ad476170e9 Improve performance of fmgr.c calling routines for cases with more than two arguments. Per suggestions from A. Ogawa. Tom Lane 2005-02-02 22:40:04 +00:00
  • 388a42c515 Adjust constant-folding of CASE expressions so that the simple comparison form of CASE (eg, CASE 0 WHEN 1 THEN ...) can be constant-folded as it was in 7.4. Also, avoid constant-folding result expressions that are certainly unreachable --- the former coding was a bit cavalier about this and could generate unexpected results for all-constant CASE expressions. Add regression test cases. Per report from Vlad Marchenko. Tom Lane 2005-02-02 21:49:49 +00:00
  • fffb5819ca Adjust constant-folding of CASE expressions so that the simple comparison form of CASE (eg, CASE 0 WHEN 1 THEN ...) can be constant-folded as it was in 7.4. Also, avoid constant-folding result expressions that are certainly unreachable --- the former coding was a bit cavalier about this and could generate unexpected results for all-constant CASE expressions. Add regression test cases. Per report from Vlad Marchenko. Tom Lane 2005-02-02 21:49:09 +00:00
  • 722c886ba1 Improve wording of to_char() change in 8.1: Bruce Momjian 2005-02-02 18:17:34 +00:00
  • b3a7e987a1 Improve wording of to_char() change in 8.1: Bruce Momjian 2005-02-02 18:16:13 +00:00
  • 6aebc34e55 Backpatch FAQ to 8.0.X. Bruce Momjian 2005-02-02 17:44:51 +00:00
  • f69513df17 Update FAQ numbering. Bruce Momjian 2005-02-02 17:44:22 +00:00