Commit Graph

  • 565b4f2de5 Use lynx -stdin and regenerate HISTORY Bruce Momjian 2004-03-06 02:52:46 +00:00
  • 96c229dd7a Improve documentation of virtual_host parameter: old text failed to indicate that you could specify multiple listen addresses. Tom Lane 2004-03-05 23:16:17 +00:00
  • 3f01eba0bf Have makefile reference /xml2. Bruce Momjian 2004-03-05 20:01:46 +00:00
  • 49bc9c45c9 Brand 7.4.2. Release notes still need work. Bruce Momjian 2004-03-05 19:57:22 +00:00
  • aeda110cb9 First update of release notes for 7.4.2. Still needs work. Bruce Momjian 2004-03-05 19:52:39 +00:00
  • ff47b8518e First update of release notes for 7.4.2. Still needs work. Bruce Momjian 2004-03-05 19:51:56 +00:00
  • 39042637dd Oops, '-' doesn't work for my lynx either. Bruce Momjian 2004-03-05 19:50:55 +00:00
  • 8fc7522cad Use '-' for stdin on lynx, my lynx version doesn't support -stdin. Bruce Momjian 2004-03-05 19:48:03 +00:00
  • aef037723f Update Polish FAQ, from Marcin Mazurek. Bruce Momjian 2004-03-05 19:29:23 +00:00
  • 3783ed3420 Add xml2 as skipped /contrib Makefile entry. Bruce Momjian 2004-03-05 05:15:16 +00:00
  • e085999662 Add mention xml2 is a newer version. Bruce Momjian 2004-03-05 04:13:15 +00:00
  • 614e42354d Add missing xml files. Bruce Momjian 2004-03-05 04:10:11 +00:00
  • 31f4b59a46 Move new version of contrib/ xml into xml2, keep old version in /xml. Bruce Momjian 2004-03-05 03:57:58 +00:00
  • adca025c9e Thanks to the generous support of Torchbox (http://www.torchbox.com), I have been able to significantly improve the contrib/xml XPath integration code. Bruce Momjian 2004-03-05 03:24:50 +00:00
  • 1973971821 Per a brief conversation with Tom, I've created a patch for adding support for 'week' within the date_trunc function. Bruce Momjian 2004-03-05 02:41:14 +00:00
  • 5b6d0a4df7 libpq's query to get the OIDs of large-object support functions was not schema-safe. Make it so, and improve the internal support for knowledge of server version. Tom Lane 2004-03-05 01:54:13 +00:00
  • 44611f6e6d libpq's query to get the OIDs of large-object support functions was not schema-safe. Make it so, and improve the internal support for knowledge of server version. Tom Lane 2004-03-05 01:53:59 +00:00
  • d91acf8401 Win32: Bruce Momjian 2004-03-05 01:11:04 +00:00
  • 033e37bed1 Fix for underscore in ID sgml markup. Bruce Momjian 2004-03-05 01:00:45 +00:00
  • 65a0db19f4 Add new SPI functions for use by PL/Java: Bruce Momjian 2004-03-05 00:47:01 +00:00
  • 4a6bf72c65 Fix log_executor_stats for non-multi queries. Backpatch to 7.4.X. Bruce Momjian 2004-03-05 00:21:51 +00:00
  • 202cbdca03 Fix log_executor_stats for non-multi queries. Backpatch to 7.4.X. Bruce Momjian 2004-03-05 00:21:41 +00:00
  • 2146bfc869 Emit a warning when an empty string is input to the oid, float4, and float8 types. This begins the deprecation of this feature: in 7.6, this input will be rejected. Neil Conway 2004-03-04 21:47:18 +00:00
  • 0b1f7cccd7 The trim function doc did not say that the second argument could be be omitted. This patch fixes that. It also fixes a bug where the type text was not wrapped as <type>text</type>. Dennis Bjorklund 2004-03-04 20:09:29 +00:00
  • f503b6a821 Better document INSTEAD behavior for rules. Bruce Momjian 2004-03-04 14:32:12 +00:00
  • ea41a8cc5f - Fixed segfault due to missing check for variable declaration. - Added check for multidimensional array usage. Michael Meskes 2004-03-04 07:38:50 +00:00
  • f3c6d592d2 - Fixed segfault due to missing check for variable declaration. - Added check for multidimensional array usage. Michael Meskes 2004-03-04 07:32:02 +00:00
  • 926fd43d77 Update build number in anticipation of 7.4.2 release. With no currently outstanding issues we'll flag now, so the release doesn't slip out the door without it. Kris Jurka 2004-03-04 03:25:10 +00:00
  • c934cf1e96 Add a few more cross-references where appropriate, add more text about the FROM clause and an example to the UPDATE reference page, and make a few other SGML tweaks. Neil Conway 2004-03-03 22:22:24 +00:00
  • 9e733eab69 Modify pg_dump so that the preferred dump order is by name within object types, rather than by OID. This should help ensure consistent dump output from databases that are logically the same but have different histories, per recent discussion about 'diffing' databases. The patch is bulky because of renaming of fields, but not very complicated. Also, do some tweaking to cause BLOB restoration to be done in a better order, and clean up pg_restore's textual output to exactly match pg_dump. Tom Lane 2004-03-03 21:28:55 +00:00
  • 6819787c9b Fix wording of new bison warning, per Peter. Bruce Momjian 2004-03-03 17:37:22 +00:00
  • 6008fca4d9 Remove Jan: Bruce Momjian 2004-03-03 14:26:48 +00:00
  • 53c1f64b29 Seems the usage message for oid2name calls it pg_oid2name. Fixed. Bruce Momjian 2004-03-03 14:24:12 +00:00
  • 58c69eab00 Add: Bruce Momjian 2004-03-03 05:16:53 +00:00
  • 119e968305 Adds the -W flag to the pwd call under Win32. This allows directories, which are munged by sed, such as: /e/cygwin/opt/diff9c/pgsql/src/test/regress/data/agg.data to be correctly passed as: e:/cygwin/opt/diff9c/pgsql/src/test/regress/data/agg.data Bruce Momjian 2004-03-03 04:22:47 +00:00
  • 0ee2603455 Remove useless rebuilding of subPlan list during ExecInitNode. Wouldn't have been there to start with, except for overly enthusiastic copy-and- paste ... Tom Lane 2004-03-02 22:17:34 +00:00
  • 13f466167d Update obsolete comment. Tom Lane 2004-03-02 22:05:24 +00:00
  • e921472fef Always schema-qualify the name of a function referenced in CREATE CAST. The former coding failed if the cast function was not in the pg_catalog schema. How'd this escape detection? Tom Lane 2004-03-02 21:15:15 +00:00
  • f0d32c033a Always schema-qualify the name of a function referenced in CREATE CAST. The former coding failed if the cast function was not in the pg_catalog schema. How'd this escape detection? Tom Lane 2004-03-02 21:14:59 +00:00
  • 0c6e97db47 Always schema-qualify the name of a function referenced in CREATE CAST. The former coding failed if the cast function was not in the pg_catalog schema. How'd this escape detection? Tom Lane 2004-03-02 21:14:44 +00:00
  • 351cf4d04e Update bison warning to be clearer about its purpose. Bruce Momjian 2004-03-02 20:08:52 +00:00
  • 819bfac66a Junkfilter logic to force a projection step during SELECT INTO was too simplistic; it recognized SELECT * FROM but not SELECT * FROM LIMIT. Per bug report from Jeff Bohmer. Tom Lane 2004-03-02 18:56:28 +00:00
  • 7bbd9d93cc Junkfilter logic to force a projection step during SELECT INTO was too simplistic; it recognized SELECT * FROM but not SELECT * FROM LIMIT. Per bug report from Jeff Bohmer. Tom Lane 2004-03-02 18:56:15 +00:00
  • aff13a9714 [ backpatch] Bruce Momjian 2004-03-02 18:38:28 +00:00
  • b95c05c9c1 Fix sizeof(Oid) in PGSTAT_NUM_TABPURGE. (Actually done in previous commit.) Bruce Momjian 2004-03-02 18:37:52 +00:00
  • 24262be5f9 Add missing checks for Borland C compiler. Bruce Momjian 2004-03-02 18:35:59 +00:00
  • 03e2a47e0b Teach is_distinct_query to recognize that GROUP BY forces a subquery's output to be distinct, if all the GROUP BY columns appear in the output. Per suggestion from Dennis Haney. Tom Lane 2004-03-02 16:42:20 +00:00
  • 887a136572 Update Turkish FAQ, Devrim GUNDUZ Bruce Momjian 2004-03-02 15:46:34 +00:00
  • 49032ca765 Update Turkish FAQ, Devrim GUNDUZ Bruce Momjian 2004-03-02 15:46:22 +00:00
  • fee9629cf1 Add missing sprompt.obj psql usage for Borland compiler, per private report from krizsan. Bruce Momjian 2004-03-02 15:17:32 +00:00
  • b57cbb4ef0 Add missing sprompt.obj psql usage for Borland compiler, per private report from krizsan. Bruce Momjian 2004-03-02 15:17:16 +00:00
  • f7a9dbce8d Added the missing rules for VOLATILE. Michael Meskes 2004-03-02 06:52:18 +00:00
  • fd104c5764 Added partly missing VOLATILE keyword. Michael Meskes 2004-03-02 06:45:05 +00:00
  • 2d558b2baa Brand 7.3.6. REL7_3_6 Tom Lane 2004-03-02 00:44:55 +00:00
  • 040f11db24 Update release notes for 7.3.6. Tom Lane 2004-03-02 00:39:09 +00:00
  • 44990772e0 Update release notes for 7.3.6. Tom Lane 2004-03-02 00:38:56 +00:00
  • 340d44686b Update release notes for 7.3.6. Tom Lane 2004-03-02 00:38:46 +00:00
  • d367707827 Replace unportable use of /dev/stdin with lynx's -stdin switch. Tom Lane 2004-03-02 00:03:15 +00:00
  • b6a7df8b29 Replace unportable use of /dev/stdin with lynx's -stdin switch. Tom Lane 2004-03-02 00:03:08 +00:00
  • 3811d7a08f Replace unportable use of /dev/stdin with lynx's -stdin switch. Tom Lane 2004-03-02 00:03:02 +00:00
  • 1a6a27650d Add a few more xrefs, where they seemed appropriate: for example, refer to the discussion of planner statistics in the documentation for the default_statistics_target GUC var. Neil Conway 2004-03-01 17:58:39 +00:00
  • 4a43b24cec Enable some additional warnings when running openjade and onsgmls. Neil Conway 2004-03-01 16:08:58 +00:00
  • f91bde3fb6 make_sort_from_pathkeys()'s method for choosing which of several equivalent sort expressions to use was broken: you can't just look at the relation membership, you have to actually grovel over the individual Vars in each expression. I think this did work when it was written, but it was broken by subsequent optimizations that made join relations not propagate every single input variable upward. Must find the Var that got propagated, not choose one at random. Per bug report from Daniel O'Neill. Tom Lane 2004-02-29 17:36:48 +00:00
  • 64917ccb56 make_sort_from_pathkeys()'s method for choosing which of several equivalent sort expressions to use was broken: you can't just look at the relation membership, you have to actually grovel over the individual Vars in each expression. I think this did work when it was written, but it was broken by subsequent optimizations that made join relations not propagate every single input variable upward. Must find the Var that got propagated, not choose one at random. Per bug report from Daniel O'Neill. Tom Lane 2004-02-29 17:36:05 +00:00
  • e3f27c1847 Fix a typo in a recent commit to func.sgml that apparently broke the doc build for some versions of OpenJade (unfortunately, my local version of OpenJade didn't report the error...) -- thanks to Andrew Dunstan for the report. Neil Conway 2004-02-29 15:45:53 +00:00
  • fd015c5c99 Fix a bunch (~88) typos that the OpenJade tools don't warn about by default: some SGML tags weren't properly terminated. Neil Conway 2004-02-29 15:36:46 +00:00
  • 31ce2fddfa "Corrects" the int8/float4/float8 tests under win32. Bruce Momjian 2004-02-29 02:41:45 +00:00
  • 9be7ea088c Remove unneeded indxqual field in IndexScanState, and the useless work spent initializing it during indexscan startup. Tom Lane 2004-02-28 19:46:06 +00:00
  • 303f4649a2 Translation updates Dennis Bjorklund 2004-02-28 17:17:48 +00:00
  • 02760606d1 Translation updates Dennis Bjorklund 2004-02-28 11:16:58 +00:00
  • b8d518c17d Translation update Dennis Bjorklund 2004-02-28 11:05:12 +00:00
  • 90aac56562 Translation updates Dennis Bjorklund 2004-02-28 11:00:06 +00:00
  • ef6e54d78b Translation updates Dennis Bjorklund 2004-02-28 10:52:06 +00:00
  • 6161766daf Adjust remove_redundant_join_clauses() so that when it has a choice of which redundant clause to remove, it removes the more expensive one. In simple scenarios the clauses will be like 'var = var' and there's no difference, but we are now capable of considering cases where there are sub-selects in the clauses, and it makes a BIG difference. Tom Lane 2004-02-27 21:48:04 +00:00
  • 5cfb44a82e genericcostestimate() neglected to include qual startup cost in indexTotalCost. I think this may not make any real difference in 7.4, but it definitely is a problem with CVS tip's new equation. Tom Lane 2004-02-27 21:44:44 +00:00
  • df79b847fe genericcostestimate() neglected to include qual startup cost in indexTotalCost. I think this may not make any real difference in 7.4, but it definitely is a problem with CVS tip's new equation. Tom Lane 2004-02-27 21:44:34 +00:00
  • 36be19e3ed process_implied_equality must copy the substructure of the clauses it is generating, to avoid problems when subselects are involved. Per report from Damon Hart. Tom Lane 2004-02-27 21:42:10 +00:00
  • f5d8f0bb19 process_implied_equality must copy the substructure of the clauses it is generating, to avoid problems when subselects are involved. Per report from Damon Hart. Tom Lane 2004-02-27 21:42:00 +00:00
  • f46a80c362 Fix a few omissions in the initcap() documentation & source code comments, make some unrelated improvements to the functions documentation, and perform some minor consistency cleanup elsewhere. Original initcap() change from Dennis B., additional changes by Neil C. Neil Conway 2004-02-27 03:59:23 +00:00
  • 2f17547c67 Update plpython docs to mention shared libs are possible in 2.3 or later. Bruce Momjian 2004-02-27 01:23:18 +00:00
  • 8878f4aee7 For immediate application to HEAD. Bruce Momjian 2004-02-26 02:59:26 +00:00
  • 23168fb3bf Update the pl/python shared build docs to match the recent version of python. Bruce Momjian 2004-02-26 02:09:40 +00:00
  • c672aa823b For application to HEAD, following community review. Bruce Momjian 2004-02-25 19:41:23 +00:00
  • 5ada9ef088 Teach plpgsql's lexer about dollar-quoted literals. Andrew Dunstan, some help from Tom Lane. Tom Lane 2004-02-25 18:10:51 +00:00
  • aed597102c anyarray really needs to be declared with typalign = 'd', so that entries in pg_statistic are correctly aligned if they contain values that require double alignment. Too bad we cannot force initdb for this in 7.4 branch. Tom Lane 2004-02-24 22:59:22 +00:00
  • fa7a3abe87 anyarray really needs to be declared with typalign = 'd', so that entries in pg_statistic are correctly aligned if they contain values that require double alignment. Too bad we cannot force initdb for this in 7.4 branch. Tom Lane 2004-02-24 22:59:10 +00:00
  • fa96a5e15b Add %option nodefault to all our flex lexers. Fix a couple of rule gaps exposed thereby. AFAICT these would not lead to any worse problems than junk emitted on the backend's stdout, but we should have the option to catch possible worse errors in future. Tom Lane 2004-02-24 22:06:32 +00:00
  • 58e705320e Implement dollar-quoting in the backend lexer and psql. Documentation is still lacking, as is support in plpgsql and other places, but this is the basic feature. Patch by Andrew Dunstan, some tweaking by Tom Lane. Also, enable %option nodefault in these two lexers, and patch some gaps revealed thereby. Tom Lane 2004-02-24 21:45:18 +00:00
  • bc0476f9c8 - Corrected error handling in PGTYPEStimestamp_from_asc. - Set pgtypeslib version to 1.2. Michael Meskes 2004-02-24 16:09:16 +00:00
  • 1f87d79142 - Corrected error handling in PGTYPEStimestamp_from_asc. - Set pgtypeslib version to 1.2. Michael Meskes 2004-02-24 16:07:49 +00:00
  • 935e6e502d Closing a Connection or Statement object twice should be a no-op instead of throwing an Exception. Kris Jurka 2004-02-24 13:11:45 +00:00
  • a7e5e2fe74 When returning type "record", replace use of pgresultGetTupleDesc with ReturnSetInfo->expectedDesc. This allows custom datatypes (e.g. from tsearch2) to be returned at runtime. Previous behavior depended on the type oid to match between the remote and local database, which obviously doesn't work well for custom types. Per report from Mark Gibson. Joe Conway 2004-02-24 06:07:52 +00:00
  • 27ae96c2b6 When returning type "record", replace use of pgresultGetTupleDesc with ReturnSetInfo->expectedDesc. This allows custom datatypes (e.g. from tsearch2) to be returned at runtime. Previous behavior depended on the type oid to match between the remote and local database, which obviously doesn't work well for custom types. Per report from Mark Gibson. Joe Conway 2004-02-24 06:07:34 +00:00
  • 3cd8411826 When returning type "record", replace use of pgresultGetTupleDesc with ReturnSetInfo->expectedDesc. This allows custom datatypes (e.g. from tsearch2) to be returned at runtime. Previous behavior depended on the type oid to match between the remote and local database, which obviously doesn't work well for custom types. Per report from Mark Gibson. Joe Conway 2004-02-24 06:07:18 +00:00
  • 7ce7e3f036 pply quote_literal to the start_with argument of connectby. Fixes problem reported by David Garamond when working with bytea parent and child keys. Joe Conway 2004-02-24 05:26:27 +00:00
  • 78c97b156e Apply quote_literal to the start_with argument of connectby. Fixes problem reported by David Garamond when working with bytea parent and child keys. Joe Conway 2004-02-24 05:26:07 +00:00
  • 64a2e1fdef Apply quote_literal to the start_with argument of connectby. Fixes problem reported by David Garamond when working with bytea parent and child keys. Joe Conway 2004-02-24 05:25:36 +00:00
  • d159c4ba4c Cause pg_dump to emit a 'SET client_encoding' command at the start of any restore operation, thereby ensuring that dumped data is interpreted the same way it was dumped even if the target database has a different encoding. Per suggestions from Pavel Stehule and others. Also, simplify scheme for handling check_function_bodies ... we may as well just set that at the head of the script. Tom Lane 2004-02-24 03:35:45 +00:00
  • 92bec9a0bc Cause pg_dump to emit a 'SET client_encoding' command at the start of any restore operation, thereby ensuring that dumped data is interpreted the same way it was dumped even if the target database has a different encoding. Per suggestions from Pavel Stehule and others. Also, simplify scheme for handling check_function_bodies ... we may as well just set that at the head of the script. Tom Lane 2004-02-24 03:35:19 +00:00
  • d301dcbe30 Don't crash when a rowtype argument to a plpgsql function is NULL. Per report from Chris Campbell. Tom Lane 2004-02-24 01:44:58 +00:00