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

Commit Graph

  • be8a431881 Add GUC log_temp_files to log the use of temporary files. Bruce Momjian 2007-01-09 21:31:17 +00:00
  • 1e0bf9041e Marginal tweaks in the documentation for ORDER BY; in particular point out the common error that ORDER BY x, y DESC does not mean the same as ORDER BY x DESC, y DESC. Tom Lane 2007-01-09 16:59:20 +00:00
  • 69db009163 Add a citation to Seltzer and Yigit's Usenix '91 paper about hash table management. The paper clearly describes many of the ideas embodied in our current hashing code, but as far as I could find out there is not a direct code heritage. (Mike Olsen recalls discussion of this paper at Postgres meetings but believes it "informed the Postgres implementation probably just at the design level". Margo herself says she wasn't involved with Postgres' hash code.) Credit where credit is due 'n all that, even if fifteen years after the fact. Tom Lane 2007-01-09 07:30:49 +00:00
  • 352871c357 Fix vcbuild to allow building without OpenSSL and/or zlib. Magnus Tom Lane 2007-01-09 06:00:43 +00:00
  • 7d5d06f860 vcbuild documentation from Magnus and Dave. Tom Lane 2007-01-09 05:56:49 +00:00
  • b0452cd87d Done: Bruce Momjian 2007-01-09 03:43:32 +00:00
  • 833f9cb7b8 pltcl regression test needs to actually create an opclass, not just one operator. Tom Lane 2007-01-09 03:13:38 +00:00
  • 4431758229 Support ORDER BY ... NULLS FIRST/LAST, and add ASC/DESC/NULLS FIRST/NULLS LAST per-column options for btree indexes. The planner's support for this is still pretty rudimentary; it does not yet know how to plan mergejoins with nondefault ordering options. The documentation is pretty rudimentary, too. I'll work on improving that stuff later. Tom Lane 2007-01-09 02:14:16 +00:00
  • 3a32ba2f3f Prevent duplicate attribute names in XMLELEMENT. Peter Eisentraut 2007-01-08 23:41:57 +00:00
  • 757dfd6327 Tweak joinlist creation to avoid generating useless one-element subproblems when collapsing of JOIN trees is stopped by join_collapse_limit. For instance a list of 11 LEFT JOINs with limit 8 now produces something like ((1 2 3 4 5 6 7 8) 9 10 11 12) instead of (((1 2 3 4 5 6 7 8) (9)) 10 11 12) The latter structure is really only required for a FULL JOIN. Noted while studying an example from Shane Ambler. Tom Lane 2007-01-08 16:47:35 +00:00
  • 19f9376bf4 Tweak joinlist creation to avoid generating useless one-element subproblems when collapsing of JOIN trees is stopped by join_collapse_limit. For instance a list of 11 LEFT JOINs with limit 8 now produces something like ((1 2 3 4 5 6 7 8) 9 10 11 12) instead of (((1 2 3 4 5 6 7 8) (9)) 10 11 12) The latter structure is really only required for a FULL JOIN. Noted while studying an example from Shane Ambler. Tom Lane 2007-01-08 16:47:30 +00:00
  • 9c1443e66f Remove cost_hashjoin's very ancient hack to discourage (once, entirely forbid) hash joins with the estimated-larger relation on the inside. There are several cases where doing that makes perfect sense, and in cases where it doesn't, the regular cost computation really ought to be able to figure that out. Make some marginal tweaks in said computation to try to get results approximating reality a bit better. Per an example from Shane Ambler. Tom Lane 2007-01-08 16:09:31 +00:00
  • 9a9a143a98 Remove cost_hashjoin's very ancient hack to discourage (once, entirely forbid) hash joins with the estimated-larger relation on the inside. There are several cases where doing that makes perfect sense, and in cases where it doesn't, the regular cost computation really ought to be able to figure that out. Make some marginal tweaks in said computation to try to get results approximating reality a bit better. Per an example from Shane Ambler. Tom Lane 2007-01-08 16:09:22 +00:00
  • d807c7ef3f Some fine-tuning of xmlpi in corner cases: - correct error codes - do syntax checks in correct order - strip leading spaces of argument Peter Eisentraut 2007-01-07 22:49:56 +00:00
  • de9aa5a7b4 Check and document minimum required version of libxml. Peter Eisentraut 2007-01-07 21:10:41 +00:00
  • fe733968ea Indent comments in makefiles better so they don't appear in the output. Peter Eisentraut 2007-01-07 08:49:31 +00:00
  • 2054724c08 Fix oversight in handling of row-comparison index keys: if the row comparison doesn't exactly match the index, we may have to change our initial positioning strategy. For example, given an index on (f1,f2,f3) and a WHERE condition "ROW(f1,f3) > ROW(2,3)", the code extracted the initial-positioning condition "f1 > 2", which is wrong ... it has to be "f1 >= 2", else some rows matching the WHERE condition may fail to be returned. Tom Lane 2007-01-07 01:56:24 +00:00
  • 53a11befc8 Allow XML fragment to contain a XML declaration. For that, we need a small hand-crafted parser for the XML declaration, because libxml doesn't seem to allow this. Peter Eisentraut 2007-01-07 00:13:55 +00:00
  • 324297dfbb Remove: Bruce Momjian 2007-01-06 22:55:09 +00:00
  • 06d009010c Updates for MONEY data type: Bruce Momjian 2007-01-06 22:24:16 +00:00
  • d23d19a1a2 Done: Bruce Momjian 2007-01-06 22:19:46 +00:00
  • 94609f0068 Add: Bruce Momjian 2007-01-06 22:18:24 +00:00
  • 147f2e916c Add: Bruce Momjian 2007-01-06 21:58:22 +00:00
  • f0f4a6d781 Apply fix so pow() and exp() ERANGE is used only if result is not 0. Bruce Momjian 2007-01-06 20:21:29 +00:00
  • 282f7f2eac Already done in 8.2: Bruce Momjian 2007-01-06 20:00:53 +00:00
  • bd87cd5ffb Move INDEX inheritance out into a separate section: Bruce Momjian 2007-01-06 20:00:10 +00:00
  • 9cfcfd7c22 Done: Bruce Momjian 2007-01-06 19:41:23 +00:00
  • c3578a68f8 Allow initdb to specify the pg_xlog directory. Bruce Momjian 2007-01-06 19:40:00 +00:00
  • 19749fb0cf Replace xmlroot with a properly functioning version that parses the value, sets the items, and serializes the value back (rather than adding an arbitrary number of XML preambles as before). Peter Eisentraut 2007-01-06 19:18:36 +00:00
  • 79a0a57581 Fix filtered_base_yylex() to save and restore base_yylval and base_yylloc properly when doing a lookahead. The lack of this was causing various interesting misbehaviors when one tries to use "with" as a plain identifier. Tom Lane 2007-01-06 19:14:27 +00:00
  • 063560bb8e Fix filtered_base_yylex() to save and restore base_yylval and base_yylloc properly when doing a lookahead. The lack of this was causing various interesting misbehaviors when one tries to use "with" as a plain identifier. Tom Lane 2007-01-06 19:14:17 +00:00
  • e85ef6e51e Document problems with release links in early branches. Bruce Momjian 2007-01-06 15:19:45 +00:00
  • e80b0bd69d Check for ERANGE in exp() as well. Bruce Momjian 2007-01-06 15:18:03 +00:00
  • 2ece6917e8 commit before tag ... REL7_4_15 PostgreSQL Daemon 2007-01-06 06:40:31 +00:00
  • a7542c3bb1 tag it REL8_0_10 PostgreSQL Daemon 2007-01-06 06:18:46 +00:00
  • 3d5f28671a Links to GUC variables from HISTORY don't work in back branches... Tom Lane 2007-01-06 06:01:48 +00:00
  • c3013376b2 Links to GUC variables from HISTORY don't work in back branches... REL8_1_6 Tom Lane 2007-01-06 06:01:37 +00:00
  • e677ff2876 tag 8.1.6 PostgreSQL Daemon 2007-01-06 05:29:03 +00:00
  • 78c795d4e5 tag configure REL8_2_1 PostgreSQL Daemon 2007-01-06 05:02:26 +00:00
  • 96959c18c6 Fix markup because older releases couldn't link to the reference section. Bruce Momjian 2007-01-06 04:17:59 +00:00
  • a05e93ed52 Fix markup because older releases couldn't link to the reference section. Bruce Momjian 2007-01-06 04:17:33 +00:00
  • 230ae1a106 Fix markup because older releases couldn't link to the reference section. Bruce Momjian 2007-01-06 04:17:15 +00:00
  • 4c884c3ceb Fix markup because older releases couldn't like to refernce pages. REL7_3_17 Bruce Momjian 2007-01-06 04:15:43 +00:00
  • 19ce06b91b Improve dpow() check for ERANGE overflow for HPPA. Bruce Momjian 2007-01-06 04:14:55 +00:00
  • c1478c8f57 Remove extra character added to top. Bruce Momjian 2007-01-06 03:36:32 +00:00
  • 77c7616482 Fix markup because lc_numeric didn't have an SGML tag in this release. Bruce Momjian 2007-01-06 03:14:32 +00:00
  • 43a9728290 Fix markup because lc_numeric didn't have an SGML tag in this release. Bruce Momjian 2007-01-06 03:14:18 +00:00
  • b2965b9fce Put back ERANGE test in dpow(). There are platforms that need this, like my HPPA ... Tom Lane 2007-01-06 02:28:38 +00:00
  • c41e33f5fa tag for 7.3.17 ... PostgreSQL Daemon 2007-01-06 02:25:19 +00:00
  • 561b4bae78 Document that we need to update the ecpg regression files when we update the library version number. Bruce Momjian 2007-01-06 00:25:11 +00:00
  • 9b1854f16e Update ecpg regresison output for new library version number. Bruce Momjian 2007-01-05 22:43:17 +00:00
  • 3941045cd3 Minor copy-editing for release note updates. Tom Lane 2007-01-05 22:35:22 +00:00
  • 6faab66422 Minor copy-editing for release note updates. Tom Lane 2007-01-05 22:35:13 +00:00
  • ccd743ef5d Minor copy-editing for release note updates. Tom Lane 2007-01-05 22:35:04 +00:00
  • 17406c92ac Minor copy-editing for release note updates. Tom Lane 2007-01-05 22:34:54 +00:00
  • acb01484d6 Minor copy-editing for release note updates. Tom Lane 2007-01-05 22:34:46 +00:00
  • 07a5a4b21e Minor copy-editing for release note updates. Tom Lane 2007-01-05 22:34:35 +00:00
  • 29dccf5fe0 Update CVS HEAD for 2007 copyright. Back branches are typically not back-stamped for this. Bruce Momjian 2007-01-05 22:20:05 +00:00
  • 7e3c689fd3 Update copyright script, report year used Bruce Momjian 2007-01-05 21:29:20 +00:00
  • 5a2a527bb5 Modify copyright script to pull current year from date. Bruce Momjian 2007-01-05 21:09:53 +00:00
  • e82da29033 Update Japanese FAQ. Bruce Momjian 2007-01-05 20:57:17 +00:00
  • c30a945c3d Update Japanese FAQ. Bruce Momjian 2007-01-05 20:56:56 +00:00
  • 4290bb4e0f Stamp release 8.2.1. Update FAQs. Bruce Momjian 2007-01-05 20:55:29 +00:00
  • 1c3b43cddd Stamp major release 8.3.0, and increment library version numbers. Bruce Momjian 2007-01-05 20:54:43 +00:00
  • 9b9758bb77 Stamp release 8.1.6. Bruce Momjian 2007-01-05 20:53:49 +00:00
  • e0f20bbe44 Stamp release 8.0.10. Bruce Momjian 2007-01-05 20:53:30 +00:00
  • 37a86cd254 Stamp release 7.4.15. Bruce Momjian 2007-01-05 20:53:11 +00:00
  • 3294607a6a Stamp release 7.3.17. Bruce Momjian 2007-01-05 20:52:58 +00:00
  • b358d9cf40 Update for release 8.2.1. Bruce Momjian 2007-01-05 20:40:30 +00:00
  • d6c8cdcceb Create release notes for release 8.2.1. Bruce Momjian 2007-01-05 20:05:47 +00:00
  • 281ae80f2a Create release notes for all back-branch relases on 2007-01-08. Bruce Momjian 2007-01-05 20:05:02 +00:00
  • f921940be5 Create release notes for 8.1.6. Bruce Momjian 2007-01-05 20:03:46 +00:00
  • 1f503f27d5 Create release notes for 8.0.10. Bruce Momjian 2007-01-05 20:03:19 +00:00
  • e105a651f7 Create release notes for 7.4.15. Bruce Momjian 2007-01-05 20:02:55 +00:00
  • 4f58c0db22 Create release notes for 7.3.17. Bruce Momjian 2007-01-05 20:02:22 +00:00
  • 226e9fffc8 Call setrlimit if possible in pg_regress to allow core file generation, and provide a switch for similar behaviour in pg_ctl. Andrew Dunstan 2007-01-05 16:17:55 +00:00
  • 138668ca37 Update float dpow() comment about whick platforms had issues with Nan. Bruce Momjian 2007-01-05 03:19:26 +00:00
  • 2ca07b0c4a Add missing reference to pg_shdescription. Greg Mullane Tom Lane 2007-01-05 01:19:04 +00:00
  • 53c26d6f8f Add missing reference to pg_shdescription. Greg Mullane Tom Lane 2007-01-05 01:18:59 +00:00
  • b1b73e93d5 Fix tab to space mention in FAQ_DEV. Bruce Momjian 2007-01-04 21:00:14 +00:00
  • e1aeba0799 Fix AddDefine to handle quotes properly. Magnus Tom Lane 2007-01-04 17:58:19 +00:00
  • 34615ce73d Tweak pg_dumpall to add GRANT CONNECT ON DATABASE ... TO PUBLIC when dumping database privileges from a pre-8.2 server. This ensures that the reloaded database will maintain the same behavior it had in the previous installation, ie, everybody has connect privilege. Per gripe from L Bayuk. Tom Lane 2007-01-04 17:49:42 +00:00
  • 2ee56b6a3a Tweak pg_dumpall to add GRANT CONNECT ON DATABASE ... TO PUBLIC when dumping database privileges from a pre-8.2 server. This ensures that the reloaded database will maintain the same behavior it had in the previous installation, ie, everybody has connect privilege. Per gripe from L Bayuk. Tom Lane 2007-01-04 17:49:37 +00:00
  • 7c8927bf08 Fix some small typos in comments. Greg Stark Tom Lane 2007-01-04 16:29:42 +00:00
  • a252994abe Simplify assignment of Inf for pow Nan (don't worry about the sign). Bruce Momjian 2007-01-04 05:18:39 +00:00
  • 4fe7a6b51e Fix erroneous implementation of -s in postmaster.c (the switch doesn't take an optarg). Add some comments noting that code in three different files has to be kept in sync. Fix erroneous description of -S switch (it sets work_mem not silent_mode), and do some light copy-editing elsewhere in postgres-ref. Tom Lane 2007-01-04 00:58:01 +00:00
  • eeb2189112 Fix erroneous implementation of -s in postmaster.c (the switch doesn't take an optarg). Add some comments noting that code in three different files has to be kept in sync. Fix erroneous description of -S switch (it sets work_mem not silent_mode), and do some light copy-editing elsewhere in postgres-ref. Tom Lane 2007-01-04 00:57:51 +00:00
  • 0b29676aa6 Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the form '^(foo)$'. Before, these could never be optimized into indexscans. The recent changes to make psql and pg_dump generate such patterns (for \d commands and -t and related switches, respectively) therefore represented a big performance hit for people with large pg_class catalogs, as seen in recent gripe from Erik Jones. While at it, be more paranoid about case-sensitivity checking in multibyte encodings, and fix some other corner cases in which a regex might be interpreted too liberally. Tom Lane 2007-01-03 22:40:04 +00:00
  • 8d96a06d43 Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the form '^(foo)$'. Before, these could never be optimized into indexscans. The recent changes to make psql and pg_dump generate such patterns (for \d commands and -t and related switches, respectively) therefore represented a big performance hit for people with large pg_class catalogs, as seen in recent gripe from Erik Jones. While at it, be more paranoid about case-sensitivity checking in multibyte encodings, and fix some other corner cases in which a regex might be interpreted too liberally. Tom Lane 2007-01-03 22:39:57 +00:00
  • 85690a0e1a Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the form '^(foo)$'. Before, these could never be optimized into indexscans. The recent changes to make psql and pg_dump generate such patterns (for \d commands and -t and related switches, respectively) therefore represented a big performance hit for people with large pg_class catalogs, as seen in recent gripe from Erik Jones. While at it, be more paranoid about case-sensitivity checking in multibyte encodings, and fix some other corner cases in which a regex might be interpreted too liberally. Tom Lane 2007-01-03 22:39:49 +00:00
  • 15888bf0c0 Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the form '^(foo)$'. Before, these could never be optimized into indexscans. The recent changes to make psql and pg_dump generate such patterns (for \d commands and -t and related switches, respectively) therefore represented a big performance hit for people with large pg_class catalogs, as seen in recent gripe from Erik Jones. While at it, be more paranoid about case-sensitivity checking in multibyte encodings, and fix some other corner cases in which a regex might be interpreted too liberally. Tom Lane 2007-01-03 22:39:42 +00:00
  • f532a22a8f Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the form '^(foo)$'. Before, these could never be optimized into indexscans. The recent changes to make psql and pg_dump generate such patterns (for \d commands and -t and related switches, respectively) therefore represented a big performance hit for people with large pg_class catalogs, as seen in recent gripe from Erik Jones. While at it, be more paranoid about case-sensitivity checking in multibyte encodings, and fix some other corner cases in which a regex might be interpreted too liberally. Tom Lane 2007-01-03 22:39:35 +00:00
  • d6061d2f31 Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the form '^(foo)$'. Before, these could never be optimized into indexscans. The recent changes to make psql and pg_dump generate such patterns (for \d commands and -t and related switches, respectively) therefore represented a big performance hit for people with large pg_class catalogs, as seen in recent gripe from Erik Jones. While at it, be more paranoid about case-sensitivity checking in multibyte encodings, and fix some other corner cases in which a regex might be interpreted too liberally. Tom Lane 2007-01-03 22:39:26 +00:00
  • 9c88830ec4 Update pow() tests to check for both errno==EDOM _and_ result==Nan, and document why this happens. Remove exp() errno check because not needed. Bruce Momjian 2007-01-03 22:05:00 +00:00
  • 812095d604 Fix erroneous error tests in pow/exp. Tom Lane 2007-01-03 19:34:23 +00:00
  • 0d5eb8f9ea Fix btree_gist for new larger money type. Tom Lane 2007-01-03 18:57:19 +00:00
  • ef07221997 Clean up smgr.c/md.c APIs as per discussion a couple months ago. Instead of having md.c return a success/failure boolean to smgr.c, which was just going to elog anyway, let md.c issue the elog messages itself. This allows better error reporting, particularly in cases such as "short read" or "short write" which Peter was complaining of. Also, remove the kluge of allowing mdread() to return zeroes from a read-beyond-EOF: this is now an error condition except when InRecovery or zero_damaged_pages = true. (Hash indexes used to require that behavior, but no more.) Also, enforce that mdwrite() is to be used for rewriting existing blocks while mdextend() is to be used for extending the relation EOF. This restriction lets us get rid of the old ad-hoc defense against creating huge files by an accidental reference to a bogus block number: we'll only create new segments in mdextend() not mdwrite() or mdread(). (Again, when InRecovery we allow it anyway, since we need to allow updates of blocks that were later truncated away.) Also, clean up the original makeshift patch for bug #2737: move the responsibility for padding relation segments to full length into md.c. Tom Lane 2007-01-03 18:11:01 +00:00
  • 990fea847f Attempt to return proper overflow/underflow messages for platforms that only return Nan and set errno for pow/exp overflow/underflow. Bruce Momjian 2007-01-03 14:35:24 +00:00
  • ada6fd63d9 For float4/8, remove errno checks for pow() and exp() because only some platforms set errno, and we already have a check macro that detects under/overflow, so there is no reason for platform-specific code anymore. Bruce Momjian 2007-01-03 04:21:47 +00:00
  • 74a40190aa Widen the money type to 64 bits. D'Arcy J.M. Cain 2007-01-03 01:19:51 +00:00