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

Commit Graph

  • 1f09a857b7 Make --with-ldap build on Unixware, per Olivier Prenant. Tom Lane 2006-12-14 21:49:54 +00:00
  • 0bc8a5b669 Remove Windows port^W^Wobsolete template file. Peter Eisentraut 2006-12-14 20:53:50 +00:00
  • e5467d9e24 Activate WIN32_STACK_RLIMIT override only on platforms where this is necessary. Peter Eisentraut 2006-12-14 20:51:14 +00:00
  • ec97c55de2 Put back yet another improperly-removed #include, per Mark Kirkwood. Tom Lane 2006-12-13 05:54:48 +00:00
  • 8283cd7663 Update entry: Bruce Momjian 2006-12-12 22:31:19 +00:00
  • bef92dadb0 Fix planner to do the right thing when a degenerate outer join (one whose joinclause doesn't use any outer-side vars) requires a "bushy" plan to be created. The normal heuristic to avoid joins with no joinclause has to be overridden in that case. Problem is new in 8.2; before that we forced the outer join order anyway. Per example from Teodor. Tom Lane 2006-12-12 21:31:09 +00:00
  • f18c57fdf1 Fix planner to do the right thing when a degenerate outer join (one whose joinclause doesn't use any outer-side vars) requires a "bushy" plan to be created. The normal heuristic to avoid joins with no joinclause has to be overridden in that case. Problem is new in 8.2; before that we forced the outer join order anyway. Per example from Teodor. Tom Lane 2006-12-12 21:31:02 +00:00
  • e1b09b59de Document that log_line_prefix %t does not print timezone on Win32. Bruce Momjian 2006-12-12 21:30:41 +00:00
  • 0afabecbfd Document that log_line_prefix %t does not print timezone on Win32. Bruce Momjian 2006-12-12 21:30:33 +00:00
  • faf69ee4a3 Oops, removed: Bruce Momjian 2006-12-12 20:34:33 +00:00
  • 0f45c0890b Add: Bruce Momjian 2006-12-12 20:33:15 +00:00
  • 9cf2706742 Allow augmenting CPPFLAGS from the configure command line. This generally works, but some platform templates overwrote it without asking. Peter Eisentraut 2006-12-12 19:43:19 +00:00
  • 9178874f34 Collect the bits of wisdom about dtrace installation in the installation chapter rather than scattering them across several incomplete fragments. Peter Eisentraut 2006-12-12 16:07:42 +00:00
  • d94fa4183f Backpatch FAQ entry for null concatenation. Bruce Momjian 2006-12-11 22:48:08 +00:00
  • 876ef5d5c9 Remove blank lines in HTML FAQ. Bruce Momjian 2006-12-11 22:46:02 +00:00
  • 051b52c886 Add FAQ entry to mention using COALESCE() for concatenation of possible NULLs. Bruce Momjian 2006-12-11 22:44:53 +00:00
  • 9fa12ddda6 Add a paramtypmod field to Param nodes. This is dead weight for Params representing externally-supplied values, since the APIs that carry such values only specify type not typmod. However, for PARAM_SUBLINK Params it is handy to carry the typmod of the sublink's output column. This is a much cleaner solution for the recently reported 'could not find pathkey item to sort' and 'failed to find unique expression in subplan tlist' bugs than my original 8.2-compatible patch. Besides, someday we might want to support typmods for external parameters ... Tom Lane 2006-12-10 22:13:27 +00:00
  • 314c7b642b Make separate targets for building printable documentation in A4 and US letter paper formats. Peter Eisentraut 2006-12-10 20:46:03 +00:00
  • 5f1f30d136 Reorganize XSLT stylesheet support. Put common things into a separate file (instead of repeating), add XSL-FO stylesheet and appropriate make rules. Peter Eisentraut 2006-12-10 16:01:06 +00:00
  • 0a265e487b Add some information about increasing JadeTeX parameters. Peter Eisentraut 2006-12-10 02:37:40 +00:00
  • 465269b8ad Drop indentation of verbatim environments in print output. This increased the build time by what seemed like infinity. Peter Eisentraut 2006-12-10 01:55:29 +00:00
  • c605441c79 Generalize Texinfo rules. Prevent them from overriding the PostScript build rules. Peter Eisentraut 2006-12-10 01:53:15 +00:00
  • 0cb91ccba9 Remove the logId/logSeg fields from pg_control, because they are not needed in normal operation, and we can avoid rewriting pg_control at every log segment switch if we don't insist that these values be valid. Reducing the number of pg_control updates is a good idea for both performance and reliability. It does make pg_resetxlog's life a bit harder, but that seems a good tradeoff; and anyway the change to pg_resetxlog amounts to automating something people formerly needed to do by hand, namely look at the existing pg_xlog files to make sure the new WAL start point was past them. Tom Lane 2006-12-08 19:50:53 +00:00
  • 98cacd1a0a Fix broken markup. Tom Lane 2006-12-08 19:16:17 +00:00
  • 543790104a Fix the build for when SHOW_MEMORY_STATS is defined. The reference to the nonexistent ShowStats variable is simply removed, per Gavin Sherry. Neil Conway 2006-12-08 02:15:07 +00:00
  • 3647ff3b3a Avoid double free of _SPI_current->tuptable. AtEOSubXact_SPI() now tries to release it in a subtransaction abort, but this neglects possibility that someone outside SPI already did. Fix is for spi.c to forget about a tuptable as soon as it's handed it back to the caller. Per bug #2817 from Michael Andreen. Tom Lane 2006-12-08 00:40:33 +00:00
  • 566480acbb Avoid double free of _SPI_current->tuptable. AtEOSubXact_SPI() now tries to release it in a subtransaction abort, but this neglects possibility that someone outside SPI already did. Fix is for spi.c to forget about a tuptable as soon as it's handed it back to the caller. Per bug #2817 from Michael Andreen. Tom Lane 2006-12-08 00:40:27 +00:00
  • 373bd34e73 Repair incorrect placement of WHERE clauses when there are multiple, rearrangeable outer joins and the WHERE clause is non-strict and mentions only nullable-side relations. New bug in 8.2, caused by new logic to allow rearranging outer joins. Per bug #2807 from Ross Cohen; thanks to Jeff Davis for producing a usable test case. Tom Lane 2006-12-07 19:33:48 +00:00
  • 8124215cc3 Repair incorrect placement of WHERE clauses when there are multiple, rearrangeable outer joins and the WHERE clause is non-strict and mentions only nullable-side relations. New bug in 8.2, caused by new logic to allow rearranging outer joins. Per bug #2807 from Ross Cohen; thanks to Jeff Davis for producing a usable test case. Tom Lane 2006-12-07 19:33:40 +00:00
  • f07f11efde Fix planning of SubLinks to ensure that Vars generated from transformation of a sublink's test expression have the correct vartypmod, rather than defaulting to -1. There's at least one place where this is important because we're expecting these Vars to be exactly equal() to those appearing in the subplan itself. This is a pretty klugy solution --- it would likely be cleaner to change Param nodes to include a typmod field --- but we can't do that in the already-released 8.2 branch. Per bug report from Hubert Fongarnand. Tom Lane 2006-12-06 19:40:08 +00:00
  • b307d7a6c4 Fix planning of SubLinks to ensure that Vars generated from transformation of a sublink's test expression have the correct vartypmod, rather than defaulting to -1. There's at least one place where this is important because we're expecting these Vars to be exactly equal() to those appearing in the subplan itself. This is a pretty klugy solution --- it would likely be cleaner to change Param nodes to include a typmod field --- but we can't do that in the already-released 8.2 branch. Per bug report from Hubert Fongarnand. Tom Lane 2006-12-06 19:40:01 +00:00
  • 886a02d1cb Add a txn_start column to pg_stat_activity. This makes it easier to identify long-running transactions. Since we already need to record the transaction-start time (e.g. for now()), we don't need any additional system calls to report this information. Neil Conway 2006-12-06 18:06:48 +00:00
  • dd740e1fd0 Various improvements to the GUC description strings. Punctuate and capitalize the strings like sentences. Remove unnecessarily specific descriptions of the units used by GUC variables, since we now allow any reasonable unit to be specified. Neil Conway 2006-12-06 17:35:49 +00:00
  • a39e3958e9 Change psql \\ example to use single quotes, per TOm. Bruce Momjian 2006-12-06 15:47:22 +00:00
  • a4242d7f87 Back out mention of port success from FAQs, per Tom, added by Simon. Bruce Momjian 2006-12-06 15:45:31 +00:00
  • a7fb173fa4 Clean up psql -c documentation that uses \\. Bruce Momjian 2006-12-06 15:40:32 +00:00
  • d7f316d28e Clean up psql -c documentation that uses \\. Bruce Momjian 2006-12-06 15:40:11 +00:00
  • a6f156b931 Make URL to docs use /current/. Bruce Momjian 2006-12-05 23:13:41 +00:00
  • 1acc2e23f4 Fix documentation example of using psql \x with a SELECT command, per Simon Riggs. Backpatch to 8.2.X. Bruce Momjian 2006-12-05 17:41:02 +00:00
  • c08cfab407 Fix documentation example of using psql \x with a SELECT command, per Simon Riggs. Backpatch to 8.2.X. Bruce Momjian 2006-12-05 17:40:55 +00:00
  • d49fa4c866 Fix typos in comments and error messages in HStore. Patch from Filip Rembialkowski, with some additional fixes by myself. Neil Conway 2006-12-05 17:36:00 +00:00
  • 5b2def8969 Update of port patches, HEAD patch only. Bruce Momjian 2006-12-05 14:47:34 +00:00
  • dfd4259e94 Fix pg_dump linking on Win32 with MSVS win32.mak: Bruce Momjian 2006-12-04 22:26:46 +00:00
  • 50a073916c Fix pg_dump linking on Win32 with MSVS win32.mak: Bruce Momjian 2006-12-04 22:26:17 +00:00
  • e1bfa1869f Patch of Win32 Encoding problem for server messages using FormatMessage() (This should have been in 8.2.0, patched to 8.2.X and HEAD): Bruce Momjian 2006-12-04 22:24:04 +00:00
  • 1e22e60505 Patch of Win32 Encoding problem for server messages using FormatMessage() (This should have been in 8.2.0, patched to 8.2.X and HEAD): Bruce Momjian 2006-12-04 22:23:40 +00:00
  • e72ef41d72 Fix core dump of ispell for case of non-successfull initialization. Previous versions aren't affected. Teodor Sigaev 2006-12-04 09:27:45 +00:00
  • 6cd9a58480 Fix core dump of ispell for case of non-successfull initialization. Previous versions aren't affected. Teodor Sigaev 2006-12-04 09:26:57 +00:00
  • 8dcc8e3761 Refactor ExecGetJunkAttribute to avoid searching for junk attributes by name on each and every row processed. Profiling suggests this may buy a percent or two for simple UPDATE scenarios, which isn't huge, but when it's so easy to get ... Tom Lane 2006-12-04 02:06:55 +00:00
  • 7f676624f6 Fix LIMIT/OFFSET for null limit values. This worked before 8.2 but was broken by the change to make limit values int8 instead of int4. (Specifically, you can do DatumGetInt32 safely on a null value, but not DatumGetInt64.) Per bug #2803 from Greg Johnson. Tom Lane 2006-12-03 21:40:13 +00:00
  • 406d028a9b Fix LIMIT/OFFSET for null limit values. This worked before 8.2 but was broken by the change to make limit values int8 instead of int4. (Specifically, you can do DatumGetInt32 safely on a null value, but not DatumGetInt64.) Per bug #2803 from Greg Johnson. Tom Lane 2006-12-03 21:40:07 +00:00
  • dca4d77798 Update 8.2.X release to say 8.2.0 instead of just 8.2. Bruce Momjian 2006-12-03 16:43:05 +00:00
  • 75330c3205 Stamp HEAD as 8.3devel. Tom Lane 2006-12-02 16:43:12 +00:00
  • 37885a4d4b Update most recent version from 8.2 to 8.2.0. Bruce Momjian 2006-12-02 12:15:50 +00:00
  • 133d1e8e5b Collect the bits of wisdom about dtrace installation in the installation chapter rather than scattering them across several incomplete fragments. Peter Eisentraut 2006-12-02 09:29:51 +00:00
  • 2f52d7260c v8.2.0 is now released ... REL8_2_0 PostgreSQL Daemon 2006-12-02 08:36:41 +00:00
  • f8660e309d Stamp 8.2, except configure.in. Bruce Momjian 2006-12-02 04:12:39 +00:00
  • 73500fd8b5 Update for release 8.2. Bruce Momjian 2006-12-02 04:12:11 +00:00
  • 579c58761c Wording refinement for external references in man pages. Peter Eisentraut 2006-12-02 01:26:19 +00:00
  • b9dbb63e48 Don't ship spi_* man pages. (We don't do that anyway, but now it's automatic.) Peter Eisentraut 2006-12-02 01:25:50 +00:00
  • 339483928d Translation updates Peter Eisentraut 2006-12-02 01:16:16 +00:00
  • ceb1cc90e3 Put release date in release notes. Tom Lane 2006-12-02 00:46:46 +00:00
  • 606b10f959 Add some documentation for DTrace support. Simon Riggs Tom Lane 2006-12-02 00:42:54 +00:00
  • d92b939a0a Make Options for Windows a second-level heading instead of first-level. Peter Eisentraut 2006-12-02 00:34:52 +00:00
  • 08fa6a6851 Editorial improvements for GIN documentation. Tom Lane 2006-12-01 23:46:46 +00:00
  • a88ec7b4bb Some more supported-platforms updates: buildfarm hare is alive again, and penguin reported in recently enough to justify the assumption that we haven't broken ARM support in 8.2. Tom Lane 2006-12-01 21:17:51 +00:00
  • 1eaf9ef62a Document the recently-understood hazard that a rollback can release row-level locks that logically should not be released, because when a subtransaction overwrites XMAX all knowledge of the previous lock state is lost. It seems unlikely that we will be able to fix this before 8.3... Tom Lane 2006-12-01 20:50:06 +00:00
  • 2244ccd408 Document the recently-understood hazard that a rollback can release row-level locks that logically should not be released, because when a subtransaction overwrites XMAX all knowledge of the previous lock state is lost. It seems unlikely that we will be able to fix this before 8.3... Tom Lane 2006-12-01 20:49:59 +00:00
  • c184470be3 Document the recently-understood hazard that a rollback can release row-level locks that logically should not be released, because when a subtransaction overwrites XMAX all knowledge of the previous lock state is lost. It seems unlikely that we will be able to fix this before 8.3... Tom Lane 2006-12-01 20:49:53 +00:00
  • 3049fe7cfa Make the bgwriter's error recovery path do smgrcloseall(). On Windows this should allow delete-pending files to actually go away, and thereby work around the various complaints we've seen about 'permission denied' errors in such cases. Should be reasonably harmless in any case... Tom Lane 2006-12-01 19:55:28 +00:00
  • b02414bb82 Editorial improvements to backup and warm-standby documentation. Tom Lane 2006-12-01 03:29:15 +00:00
  • f378ccc261 Minor wording improvements. Tom Lane 2006-12-01 03:19:48 +00:00
  • da6daee216 Adjust the description of locking to clarify that locks held by a subtransaction are released if the subtransaction aborts --- in user-level terminology, this means either rolling back to a savepoint or escaping from a plpgsql exception block. Per recent suggestion from Simon. Tom Lane 2006-12-01 01:04:36 +00:00
  • 746330e2d0 Better solution to the tr problem: use sed instead. Per Martijn and Andrew. Tom Lane 2006-11-30 22:21:24 +00:00
  • 7ac9d45f49 Improve portability of 'tr' invocation in PGAC_ARG_CHECK. Reported by Olivier Prenant, fixed by Peter. Tom Lane 2006-11-30 21:44:12 +00:00
  • cd99debb3d Update supported-platforms list based on recent buildfarm results. Tom Lane 2006-11-30 21:30:22 +00:00
  • f1e3e3238d Fix typos Peter Eisentraut 2006-11-30 20:50:44 +00:00
  • 5f60086e10 Minor adjustments to make failures in startup/shutdown behave more cleanly. StartupXLOG and ShutdownXLOG no longer need to be critical sections, because in all contexts where they are invoked, elog(ERROR) would be translated to elog(FATAL) anyway. (One change in bgwriter.c is needed to make this true: set ExitOnAnyError before trying to exit. This is a good fix anyway since the existing code would have gone into an infinite loop on elog(ERROR) during shutdown.) That avoids a misleading report of PANIC during semi-orderly failures. Modify the postmaster to include the startup process in the set of processes that get SIGTERM when a fast shutdown is requested, and also fix it to not try to restart the bgwriter if the bgwriter fails while trying to write the shutdown checkpoint. Net result is that "pg_ctl stop -m fast" does something reasonable for a system in warm standby mode, and so should Unix system shutdown (ie, universal SIGTERM). Per gripe from Stephen Harris and some corner-case testing of my own. Tom Lane 2006-11-30 18:29:12 +00:00
  • ef148d6b85 Fix bug with page deletion. If inner page is removed and it tries to remove page on next level linked from next inner page, ginScanToDelete() wrongly sets parent page. Bug reveals when many item pointers from index was deleted ( several hundred thousands). Teodor Sigaev 2006-11-30 16:22:32 +00:00
  • cf06c2e5d4 Fix Makefile problem which prevented installation on VPATH builds. Alvaro Herrera 2006-11-29 21:21:03 +00:00
  • 59cf88da91 Ignore libedit/libreadline while probing for strlcpy and some other standard functions. Per report from Stefan Kaltenbrunner. Tom Lane 2006-11-29 20:12:31 +00:00
  • ae8c1bea02 More MSVC build support from Magnus. Tom Lane 2006-11-29 19:49:31 +00:00
  • 0943799f2d Spelling fix Peter Eisentraut 2006-11-29 14:50:07 +00:00
  • 7bbe35a540 Add an example showing how to cope with mixed-case names in pg_dump switches. Tom Lane 2006-11-28 22:54:18 +00:00
  • 8462c4a5b4 Update timezone data to tzdata2006p zic distribution. It seems Western Australia decided to institute DST with one month's notice ... way to go, politicians. Tom Lane 2006-11-28 19:37:23 +00:00
  • 95f6a47f1a Update timezone data to tzdata2006p zic distribution. It seems Western Australia decided to institute DST with one month's notice ... way to go, politicians. Tom Lane 2006-11-28 19:37:13 +00:00
  • 765cc1588f Update timezone data to tzdata2006p zic distribution. It seems Western Australia decided to institute DST with one month's notice ... way to go, politicians. Tom Lane 2006-11-28 19:37:03 +00:00
  • 923ec1a19f Mark to_number() and the numeric-type variants of to_char() as stable, not immutable, because their results depend on lc_numeric; this is a longstanding oversight. We cannot force initdb for this in the back branches, but we can at least provide correct catalog entries for future installations. Tom Lane 2006-11-28 19:19:25 +00:00
  • 8eb0f23a96 Mark to_number() and the numeric-type variants of to_char() as stable, not immutable, because their results depend on lc_numeric; this is a longstanding oversight. We cannot force initdb for this in the back branches, but we can at least provide correct catalog entries for future installations. Tom Lane 2006-11-28 19:19:16 +00:00
  • 894bfdcdb0 Mark to_number() and the numeric-type variants of to_char() as stable, not immutable, because their results depend on lc_numeric; this is a longstanding oversight. We cannot force initdb for this in the back branches, but we can at least provide correct catalog entries for future installations. Tom Lane 2006-11-28 19:19:07 +00:00
  • 0b11a15259 Mark to_number() and the numeric-type variants of to_char() as stable, not immutable, because their results depend on lc_numeric; this is a longstanding oversight. We cannot force initdb for this in the back branches, but we can at least provide correct catalog entries for future installations. Tom Lane 2006-11-28 19:18:56 +00:00
  • 64353640e8 Mark to_char(timestamp without timezone) as stable, not immutable, since its result now depends on the lc_messages setting, as noted by Bruce. Also, mark to_number() and the numeric-type variants of to_char() as stable, because their results depend on lc_numeric; this is a longstanding oversight. Also, mark to_date() and to_char(interval) as stable; although these appear not to depend on any GUC variables as of CVS HEAD, that seems a property unlikely to survive future improvements. It seems best to mark all the formatting functions stable and be done with it. catversion not bumped, because this does not seem critical enough to force a post-RC1 initdb, and anyway we cannot do so in the back branches. Tom Lane 2006-11-28 19:18:44 +00:00
  • a75ccd1def Fix some translator comments so that xgettext finds them and pgindent does not destroy them. Maybe we can adjust pgindent sometime. Peter Eisentraut 2006-11-28 12:54:42 +00:00
  • b64d2d2133 Add workaround for localizing May and abbreviated May differently. Idea of Dennis Björklund. Peter Eisentraut 2006-11-28 12:53:44 +00:00
  • 09309df9a2 Also install ecpg_config.h Michael Meskes 2006-11-28 12:44:06 +00:00
  • 583159ff69 Back-patch HEAD's fixes to recognize __ppc64__ as equivalent to __powerpc64__. Per confirmation from Brian Wipf that this is correct and necessary for Darwin 64-bit. Tom Lane 2006-11-28 05:54:32 +00:00
  • 6db9d26727 Add $(CFLAGS) to the simplified build rule for .so libraries on Darwin. Arguably we should do this on *all* platforms, but for the moment I'll be conservative and just do it where it's demonstrably needed. Per report from Brian Wipf. Tom Lane 2006-11-28 05:47:16 +00:00
  • fa8e42dff1 Add $(CFLAGS) to the simplified build rule for .so libraries on Darwin. Arguably we should do this on *all* platforms, but for the moment Ill Tom Lane 2006-11-28 05:45:43 +00:00
  • 796a3f373a protect vfprintf from hijacking by Windows gettext just like other members of the *printf family. Andrew Dunstan 2006-11-28 01:12:34 +00:00
  • c15de02f61 Fix inheritance description to note that not-null constraints are inherited, per Taiki Yamaguchi. Tom Lane 2006-11-28 01:09:01 +00:00