Commit Graph

  • da1738a178 This patch improves the documentation for SERIAL columns a little bit. Bruce Momjian 2002-12-06 05:17:42 +00:00
  • 982b26c0a9 RANDOM_PAGE_COST clarification of docs. Bruce Momjian 2002-12-06 05:17:03 +00:00
  • ab6e38e40a Thank you very much, you catch it :). This bug had a long life, because it exists if and only if locale of postmaster was a different from C (or ru_RU.KOI8-R). Bruce Momjian 2002-12-06 05:15:32 +00:00
  • a2bd3e2085 Thank you very much, you catch it :). This bug had a long life, because it exists if and only if locale of postmaster was a different from C (or ru_RU.KOI8-R). Bruce Momjian 2002-12-06 05:15:02 +00:00
  • f679690621 Mark ALTER DOMAIN as supported, fix typo in header. Bruce Momjian 2002-12-06 05:07:16 +00:00
  • 05a6b37912 Re-addd Rod's ALTER DOMAIN patch. Bruce Momjian 2002-12-06 05:00:34 +00:00
  • 78705d0a19 Add file. Bruce Momjian 2002-12-06 04:40:58 +00:00
  • 6e9adbe191 Add SGML file. Bruce Momjian 2002-12-06 04:40:36 +00:00
  • 38ffbb95d5 Back out V6 code, caused postmaster startup failure. Bruce Momjian 2002-12-06 04:37:05 +00:00
  • 4bfd1ad9e0 Add missing v6utils file. Bruce Momjian 2002-12-06 04:18:11 +00:00
  • 3bf160131d Updated IPv6 patch to fix netmask. Bruce Momjian 2002-12-06 03:49:19 +00:00
  • 8fc86dd593 We have just finished porting the old KAME IPv6 patch over to postgresql version 7.3, but yea... this patch adds full IPv6 support to postgres. I've tested it out on 7.2.3 and has been running perfectly stable. Bruce Momjian 2002-12-06 03:46:37 +00:00
  • 87cba401a4 Some time ago John Gray <jgray@azuli.co.uk> and myself worked out and tested a patch to contrib/xml where the existing code was causing postgres to crash when it encountered & entities in the XML. I've enclosed a patch that John came up with to correct this problem. It patches against 7.3 and will apply on 7.2x if the elog WARNING calls are changed to elog NOTICE. Bruce Momjian 2002-12-06 03:44:14 +00:00
  • 5b4c16e099 Back out ALTER DOMAIN patch until missing file appears. Bruce Momjian 2002-12-06 03:43:35 +00:00
  • 853153ca6d ALTER DOMAIN .. SET / DROP NOT NULL ALTER DOMAIN .. SET / DROP DEFAULT ALTER DOMAIN .. ADD / DROP CONSTRAINT Bruce Momjian 2002-12-06 03:28:34 +00:00
  • 36580c8e21 PyGreSQL inserttable patch ===================== Bruce Momjian 2002-12-06 03:19:28 +00:00
  • d851f002a4 With a recent commit truncate is transaction safe in 7.4. Bruce Momjian 2002-12-06 03:15:07 +00:00
  • ceab6f7283 As far as I figured from the source code this function only deals with cleaning up locale names and nothing else. Since all the locale names are in plain ASCII I think it will be safe to use ASCII-only lower-case conversion. Bruce Momjian 2002-12-05 23:21:07 +00:00
  • 500677c40f localbuf.c must be able to do blind writes. Tom Lane 2002-12-05 22:48:10 +00:00
  • a2e8e15dd4 localbuf.c must be able to do blind writes. Tom Lane 2002-12-05 22:48:03 +00:00
  • 0e98ae22d3 Avoid pulling up sublinks from a subselect's targetlist. Works around problems that occur if sublink is referenced via a join alias variable. Perhaps this can be improved later, but a simple and safe fix is needed for 7.3.1. Tom Lane 2002-12-05 21:46:55 +00:00
  • 993b145d7f Avoid pulling up sublinks from a subselect's targetlist. Works around problems that occur if sublink is referenced via a join alias variable. Perhaps this can be improved later, but a simple and safe fix is needed for 7.3.1. Tom Lane 2002-12-05 21:46:37 +00:00
  • 530bf204f0 It looks like the problem was introduced when the "SET autocommit" and "SET search_path" commands were added to the beginning of the script. Bruce Momjian 2002-12-05 21:04:14 +00:00
  • fae2f14cdd It looks like the problem was introduced when the "SET autocommit" and "SET search_path" commands were added to the beginning of the script. Bruce Momjian 2002-12-05 21:03:51 +00:00
  • ec0a5b9e9d Add: Bruce Momjian 2002-12-05 20:30:36 +00:00
  • f7a3d742df Clearify variables names so it is clear which variable is the client-supplied password and which is from pg_shadow. Bruce Momjian 2002-12-05 18:52:43 +00:00
  • 24536e5b3f Allow 'password' encryption even when pg_shadow has MD5 passwords, per report from Terry Yapt and Hiroshi. Bruce Momjian 2002-12-05 18:40:08 +00:00
  • 44ab596b01 Allow 'password' encryption even when pg_shadow has MD5 passwords, per report from Terry Yapt and Hiroshi. Bruce Momjian 2002-12-05 18:39:43 +00:00
  • 1fd0c59e25 Phase 1 of read-only-plans project: cause executor state nodes to point to plan nodes, not vice-versa. All executor state nodes now inherit from struct PlanState. Copying of plan trees has been simplified by not storing a list of SubPlans in Plan nodes (eliminating duplicate links). The executor still needs such a list, but it can build it during ExecutorStart since it has to scan the plan tree anyway. No initdb forced since no stored-on-disk structures changed, but you will need a full recompile because of node-numbering changes. Tom Lane 2002-12-05 15:50:39 +00:00
  • 0f3b83edfa Improvements from Neil Conway. Bruce Momjian 2002-12-05 05:47:44 +00:00
  • 23e88e25d6 Document get/set bit/byte functions. Bruce Momjian 2002-12-05 04:38:30 +00:00
  • 7816c7cb94 More cleanup of userid to be AclId rather than Oid. Bruce Momjian 2002-12-05 04:04:51 +00:00
  • caaf941070 changed sort of column names to sort by attnum, not attname Dave Cramer 2002-12-05 01:11:43 +00:00
  • 0ea3b7b86f changed sort of column names to sort by attnum, not attname Dave Cramer 2002-12-05 01:09:58 +00:00
  • ec1bee1478 Update docs mention of query string for debug_ commands, from Joseph Shraibman. Bruce Momjian 2002-12-04 21:43:07 +00:00
  • 53e2b794f9 Repair oversight in recent change of dependency extraction code: when recursing to handle a join alias var, the context had better be set to be appropriate to the join var's query level. Per report from Hristo Neshev. Tom Lane 2002-12-04 20:00:37 +00:00
  • b8b92c6908 Repair oversight in recent change of dependency extraction code: when recursing to handle a join alias var, the context had better be set to be appropriate to the join var's query level. Per report from Hristo Neshev. Tom Lane 2002-12-04 20:00:19 +00:00
  • 20f2872467 Add: Bruce Momjian 2002-12-04 18:23:47 +00:00
  • 5cdf45c6aa Stamp minor version numbers for 7.4 release. Bruce Momjian 2002-12-04 18:14:11 +00:00
  • e3d7c9ba54 Remove typprtlen from getdescr() as it is not available in 7.3. Return -1 for that field so that existing programs don't break. D'Arcy J.M. Cain 2002-12-04 12:23:42 +00:00
  • 93902e9521 Make usesysid consistently int4, not oid. Bruce Momjian 2002-12-04 05:18:38 +00:00
  • 91f508ae85 Done: Bruce Momjian 2002-12-03 22:10:47 +00:00
  • 6f0ebe3fba Deal with cases where getpeereid _and_ another creditial method is supported. Bruce Momjian 2002-12-03 22:09:20 +00:00
  • f988edb4e1 Add OpenBSD local indent credentials, from William Ahern. Bruce Momjian 2002-12-03 21:50:44 +00:00
  • 31504cc83b Updated: Bruce Momjian 2002-12-03 17:38:34 +00:00
  • 5b827b68db Fix off-by-one bug in usage check. Tom Lane 2002-12-03 07:12:23 +00:00
  • 565dcdf77f Fix off-by-one bug in usage check. Tom Lane 2002-12-03 07:12:18 +00:00
  • d117782a4b Add for D'Arcy: Bruce Momjian 2002-12-02 05:42:36 +00:00
  • 4390ebc505 Repair core dump when trying to delete an entry from an already-NULL datconfig or useconfig field. Per report from Dustin Sallings. Tom Lane 2002-12-02 05:21:02 +00:00
  • 2802668159 Repair core dump when trying to delete an entry from an already-NULL datconfig or useconfig field. Per report from Dustin Sallings. Tom Lane 2002-12-02 05:20:47 +00:00
  • 22499b4854 Fix script name in README. Tom Lane 2002-12-02 00:29:05 +00:00
  • dfebfc1bc8 Fix script name in README. Tom Lane 2002-12-02 00:29:01 +00:00
  • 2d9d28038d Fix dependency generation for multicolumn foreign keys. From Adam Buraczewski. Tom Lane 2002-12-02 00:28:34 +00:00
  • b168915643 Fix dependency generation for multicolumn foreign keys. From Adam Buraczewski. Tom Lane 2002-12-02 00:28:29 +00:00
  • c9a993ccf3 Done in 7.3, so removed: Bruce Momjian 2002-12-01 21:28:01 +00:00
  • 68b944757a Done: Bruce Momjian 2002-12-01 21:20:45 +00:00
  • 8e3a87fbd4 Teach planner to expand sufficiently simple SQL-language functions ('SELECT expression') inline, like macros, during the constant-folding phase of planning. The actual expansion is not difficult, but checking that we're not changing the semantics of the call turns out to be more subtle than one might think; in particular must pay attention to permissions issues, strictness, and volatility. Tom Lane 2002-12-01 21:05:14 +00:00
  • 02f8c9a382 Fix ExecMakeTableFunctionResult() to work with generic expressions as well as function calls. This is needed for cases where the planner has constant-folded or inlined the original function call. Possibly we should back-patch this change into 7.3 branch as well. Tom Lane 2002-12-01 20:27:32 +00:00
  • dac011ebb3 Fix pg_dump failure against 7.1 or older servers, per report from Philip Warner. Tom Lane 2002-12-01 18:44:09 +00:00
  • 9ee7409ef7 Fix pg_dump failure against 7.1 or older servers, per report from Philip Warner. Tom Lane 2002-12-01 18:44:00 +00:00
  • 3a18f01b7a Run COPY OUT in a temporary memory context that's reset once per row, and eliminate its manual pfree() calls. This solves the encoding-conversion bug recently reported, and should be faster and more robust than the original coding anyway. For example, we are no longer at risk if datatype output routines leak memory or choose to return a constant string. Tom Lane 2002-12-01 18:14:22 +00:00
  • cc7883a1a2 Repair coredump in COPY OUT when client encoding is different from server encoding, per report from Nicolai Tufar. This is a minimum-risk patch for 7.3.1 --- I intend to apply a more general repair in HEAD. Tom Lane 2002-12-01 17:33:33 +00:00
  • 2b7ec402c4 Code review for IS DISTINCT FROM patch. Fix incorrect constant-folding logic, dissuade planner from thinking that 'x IS DISTINCT FROM 42' may be optimized into 'x = 42' (!!), cause dependency on = operator to be recorded correctly, minor other improvements. Tom Lane 2002-11-30 21:25:08 +00:00
  • 36c356e799 Missed one place that can be simplified after recent Param/Const cleanup. Tom Lane 2002-11-30 18:28:49 +00:00
  • 935969415a Be more realistic about plans involving Materialize nodes: take their cost into account while planning. Tom Lane 2002-11-30 05:21:03 +00:00
  • 829cedc8cf Make install and clean targets behave more normally. Tom Lane 2002-11-30 00:22:39 +00:00
  • ddb2d78de0 Upgrade planner and executor to allow multiple hash keys for a hash join, instead of only one. This should speed up planning (only one hash path to consider for a given pair of relations) as well as allow more effective hashing, when there are multiple hashable joinclauses. Tom Lane 2002-11-30 00:08:22 +00:00
  • f68f11928d Tighten selection of equality and ordering operators for grouping operations: make sure we use operators that are compatible, as determined by a mergejoin link in pg_operator. Also, add code to planner to ensure we don't try to use hashed grouping when the grouping operators aren't marked hashable. Tom Lane 2002-11-29 21:39:12 +00:00
  • f278d8134e Repair prehistoric logic error in lseg_eq and lseg_ne. Tom Lane 2002-11-29 19:25:38 +00:00
  • 851a4c48fd Repair prehistoric logic error in lseg_eq and lseg_ne. Tom Lane 2002-11-29 19:25:33 +00:00
  • 0a013c843b Suppress compiler warning from newer gcc. Tom Lane 2002-11-29 19:03:01 +00:00
  • 3026493ff2 This patch fixes two tiny memory leaks in pg_dump and two in pg_dumpall. Bruce Momjian 2002-11-29 16:38:42 +00:00
  • cf4e603e2c Add trigger emails. Bruce Momjian 2002-11-28 20:05:13 +00:00
  • 920c586f70 rm should be rm -f, per comment from Peter Harris. (Checked with Peter Eisentraut.) REL7_3 Tom Lane 2002-11-27 23:21:20 +00:00
  • 1941887d6e rm should be rm -f, per comment from Peter Harris. (Checked with Peter Eisentraut.) Tom Lane 2002-11-27 23:21:12 +00:00
  • 73235a19cf Improve some comments. Tom Lane 2002-11-27 20:52:04 +00:00
  • fd89de5156 Add note that scaling factor should be >= # of clients. Tom Lane 2002-11-27 19:26:10 +00:00
  • 19ddc7ec17 Update resultmap pattern for geometry-solaris-i386-pc: should match solaris 2.8 as well as 2.7. Per report from Martin Renters. Tom Lane 2002-11-27 17:04:45 +00:00
  • b4e334b6e6 Synced parser with backend Michael Meskes 2002-11-27 08:30:27 +00:00
  • 9c54c5f468 Update TODO in 7.3 branch Bruce Momjian 2002-11-26 22:06:26 +00:00
  • c4439536e2 Move to URGENT, for Justin: Bruce Momjian 2002-11-26 22:05:49 +00:00
  • b010b9d78e Recreate HISTORY file to match release.sgml changes. Stamp 7.3 final in configure/configure.in. Bruce Momjian 2002-11-26 22:04:55 +00:00
  • 75d1ed3392 Recreate HISTORY file to match release.sgml changes. Stamp 7.3 final in configure/configure.in. Bruce Momjian 2002-11-26 22:04:03 +00:00
  • 80e6d99731 Add -cmdTuples to tcl interface. Bruce Momjian 2002-11-26 21:38:49 +00:00
  • 7fb0d91062 Update trigger discussion. Bruce Momjian 2002-11-26 19:43:53 +00:00
  • c02e607d3b Update build rules for /HISTORY. Bruce Momjian 2002-11-26 19:22:40 +00:00
  • 22a717a18e Update build rules for /HISTORY. Bruce Momjian 2002-11-26 19:22:16 +00:00
  • 021f22605d Add to trigger thread. Bruce Momjian 2002-11-26 18:54:26 +00:00
  • 94b821f0e4 Fix typo in release notes. Bruce Momjian 2002-11-26 05:17:27 +00:00
  • 2a8e2d292a Fix typo in release notes. Bruce Momjian 2002-11-26 05:16:59 +00:00
  • 805acc16b8 Allocate proper length for sprintf string, from Tatsuo. Bruce Momjian 2002-11-26 03:08:23 +00:00
  • 46f4ed4921 Allocate proper length for sprintf string, from Tatsuo. Bruce Momjian 2002-11-26 03:08:00 +00:00
  • ea0b5c8569 Use Params, rather than run-time-modified Const nodes, to handle sublink results and COPY's domain constraint checking. A Const that isn't really constant is just a Bad Idea(tm). Remove hacks in parse_coerce and other places that were needed because of the former klugery. Tom Lane 2002-11-26 03:01:59 +00:00
  • d59f12daee Guard against 0 length string encoding conversion case. Tatsuo Ishii 2002-11-26 02:37:13 +00:00
  • ac47950238 Guard against 0 length string encoding conversion case. Tatsuo Ishii 2002-11-26 02:22:29 +00:00
  • f5d7da3041 Remove check for pg_group file as part of initdb -W password assignment --- not needed. Bruce Momjian 2002-11-25 21:42:11 +00:00
  • 9645fa8ccd Remove check for pg_group file as part of initdb -W password assignment --- not needed. Bruce Momjian 2002-11-25 21:41:46 +00:00
  • f893ee271f Remove unused constisset and constiscast fields of Const nodes. Clean up code and documentation associated with Param nodes. Tom Lane 2002-11-25 21:29:42 +00:00
  • dbe100c402 Restructure outfuncs and readfuncs to use macros in the same style as just done for copyfuncs/equalfuncs. Read functions in particular get a lot shorter than before, and it's much easier to compare an out function with the corresponding read function to make sure they agree. initdb forced due to small changes in nodestring format (regularizing a few cases that were formerly idiosyncratic). Tom Lane 2002-11-25 18:12:12 +00:00
  • 0aa5b6866e Un-break triggers declared for INSERT OR DELETE OR UPDATE. This worked okay in 7.3, so I think it must have been busted in the recent triggers patch. Tom Lane 2002-11-25 03:36:50 +00:00