]> granicus.if.org Git - postgresql/log
postgresql
21 years agoMore release-notes copy editing, from Neil Conway.
Tom Lane [Sun, 16 Nov 2003 03:23:57 +0000 (03:23 +0000)]
More release-notes copy editing, from Neil Conway.

21 years agoSecond try at adjusting translations for last-minute changes.
Peter Eisentraut [Sat, 15 Nov 2003 23:04:13 +0000 (23:04 +0000)]
Second try at adjusting translations for last-minute changes.

21 years agoA little bit more copy-editing...
Tom Lane [Sat, 15 Nov 2003 20:01:20 +0000 (20:01 +0000)]
A little bit more copy-editing...

21 years agoMinor wording improvement suggested by a comment in the interactive docs.
Tom Lane [Sat, 15 Nov 2003 19:46:36 +0000 (19:46 +0000)]
Minor wording improvement suggested by a comment in the interactive docs.

21 years agoMake creation of statistics collection socket more robust, by allowing it
Tom Lane [Sat, 15 Nov 2003 17:24:19 +0000 (17:24 +0000)]
Make creation of statistics collection socket more robust, by allowing it
to try additional addresses returned from getaddrinfo() if the first one
fails at the bind() or connect() steps.  Per yesterday's discussion.

21 years agoPunctuation improvements
Peter Eisentraut [Sat, 15 Nov 2003 17:20:40 +0000 (17:20 +0000)]
Punctuation improvements

21 years agoTranslation update
Peter Eisentraut [Sat, 15 Nov 2003 17:15:38 +0000 (17:15 +0000)]
Translation update

21 years agoAdjust translations for CREATE TABLE reference page change.
Peter Eisentraut [Sat, 15 Nov 2003 12:54:28 +0000 (12:54 +0000)]
Adjust translations for CREATE TABLE reference page change.

21 years agoTranslation updates
Peter Eisentraut [Sat, 15 Nov 2003 10:20:02 +0000 (10:20 +0000)]
Translation updates

21 years agoCorrect names of people with funny characters.
Peter Eisentraut [Sat, 15 Nov 2003 01:16:53 +0000 (01:16 +0000)]
Correct names of people with funny characters.

21 years agoRepair error in syntax documentation for CREATE TABLE: one does not put
Tom Lane [Fri, 14 Nov 2003 22:56:25 +0000 (22:56 +0000)]
Repair error in syntax documentation for CREATE TABLE: one does not put
a comma between multiple column_constraint's for a single column.
Per report from Tomislaw Kitynski.

21 years agoUpdate FAQ_MSWIN for 7.4 branch.
Bruce Momjian [Fri, 14 Nov 2003 18:07:48 +0000 (18:07 +0000)]
Update FAQ_MSWIN for 7.4 branch.

21 years agoUpdate FAQ and TODO for 7.4.
Bruce Momjian [Fri, 14 Nov 2003 17:54:16 +0000 (17:54 +0000)]
Update FAQ and TODO for 7.4.

21 years agoAdd release date for 7.4.
Bruce Momjian [Fri, 14 Nov 2003 17:47:49 +0000 (17:47 +0000)]
Add release date for 7.4.

21 years agoFix misstatement about the required value of SEMVMX. Given our current
Tom Lane [Fri, 14 Nov 2003 15:43:34 +0000 (15:43 +0000)]
Fix misstatement about the required value of SEMVMX.  Given our current
usage of PGSemaMagic, the minimum required value is actually 537, but
say 1000 just to use a round number.  255 is *not* good enough.

21 years agoUpdate HISTORY to match release.sgml.
Bruce Momjian [Fri, 14 Nov 2003 03:41:25 +0000 (03:41 +0000)]
Update HISTORY to match release.sgml.

21 years agoUpdate bug template to 7.4 --- that was the only one missing.
Bruce Momjian [Fri, 14 Nov 2003 03:31:05 +0000 (03:31 +0000)]
Update bug template to 7.4 --- that was the only one missing.

21 years agoTranslation updates
Peter Eisentraut [Fri, 14 Nov 2003 02:05:04 +0000 (02:05 +0000)]
Translation updates

21 years agoBeat some sense into the release notes.
Peter Eisentraut [Fri, 14 Nov 2003 02:04:05 +0000 (02:04 +0000)]
Beat some sense into the release notes.

21 years agoRegenerate text files.
Peter Eisentraut [Thu, 13 Nov 2003 17:59:35 +0000 (17:59 +0000)]
Regenerate text files.

21 years agoAdd final port reports.
Peter Eisentraut [Thu, 13 Nov 2003 17:58:35 +0000 (17:58 +0000)]
Add final port reports.

21 years agoUpdate win32 include file on 7.4 branch.
Bruce Momjian [Thu, 13 Nov 2003 05:06:56 +0000 (05:06 +0000)]
Update win32 include file on 7.4 branch.

21 years agoAcceptResult() was missing a case for PGRES_EMPTY_QUERY --- probably
Tom Lane [Wed, 12 Nov 2003 22:55:42 +0000 (22:55 +0000)]
AcceptResult() was missing a case for PGRES_EMPTY_QUERY --- probably
my fault.  Adding it fixes bogus message display when reading a block
comment at the end of a script file.

21 years agoDocumentation cleanup
Peter Eisentraut [Wed, 12 Nov 2003 20:05:15 +0000 (20:05 +0000)]
Documentation cleanup

21 years agoCommit the remaining parts of the array changes.
Michael Meskes [Wed, 12 Nov 2003 08:42:57 +0000 (08:42 +0000)]
Commit the remaining parts of the array changes.

21 years agoHere's some improvements. I just ended up referring people to Jason's
Bruce Momjian [Wed, 12 Nov 2003 04:14:34 +0000 (04:14 +0000)]
Here's some improvements.  I just ended up referring people to Jason's
website for install as service, because it's a quite a long and complex
process.

Christopher Kings-Lynne

21 years agoHere's a patch that adds some text mentioning that
Bruce Momjian [Wed, 12 Nov 2003 04:08:14 +0000 (04:08 +0000)]
Here's a patch that adds some text mentioning that
RESTRICT is not deferrable to the create table reference
page.

Stephan Szabo

21 years agoTypo fix in comment from David Wheeler
Bruce Momjian [Wed, 12 Nov 2003 03:28:45 +0000 (03:28 +0000)]
Typo fix in comment from David Wheeler

21 years agoDefault ioctlsocket_ret to 1 in case Cygwin needs it for 7.4 --- already
Bruce Momjian [Tue, 11 Nov 2003 21:37:35 +0000 (21:37 +0000)]
Default ioctlsocket_ret to 1 in case Cygwin needs it for 7.4 --- already
in HEAD.

21 years agoFix thinko in reltime and tinterval operator classes that I added a
Tom Lane [Tue, 11 Nov 2003 21:23:26 +0000 (21:23 +0000)]
Fix thinko in reltime and tinterval operator classes that I added a
couple months ago: the >= and > operators were swapped.  Not worth
forcing an initdb for this, but we should get it right in the release.
Will be patched separately in HEAD.

21 years agoRe-added forgotten cache.
Michael Meskes [Mon, 10 Nov 2003 20:28:06 +0000 (20:28 +0000)]
Re-added forgotten cache.

21 years agoautoconf REL7_4_RC2
PostgreSQL Daemon [Mon, 10 Nov 2003 05:56:23 +0000 (05:56 +0000)]
autoconf

21 years agomake sure we are tag'd for RC2
PostgreSQL Daemon [Mon, 10 Nov 2003 05:47:06 +0000 (05:47 +0000)]
make sure we are tag'd for RC2

21 years agoI have attached a more comprehensive MSWIN FAQ patch. Basically, the
Bruce Momjian [Sun, 9 Nov 2003 03:47:59 +0000 (03:47 +0000)]
I have attached a more comprehensive MSWIN FAQ patch.  Basically, the
instructions were way out of date and incorrect.  Installing Postgres
from Cygwin is easier these days than the FAQ would imply.

This patch already includes Andrew's previous patch.

Christopher Kings-Lynne

21 years agoFix typo on autovacuum readme.
Bruce Momjian [Sun, 9 Nov 2003 03:17:37 +0000 (03:17 +0000)]
Fix typo on autovacuum readme.

21 years agoAllow tab completion for ALTER TABLE dbname <tab><tab> to show new
Bruce Momjian [Sat, 8 Nov 2003 20:54:37 +0000 (20:54 +0000)]
Allow tab completion for ALTER TABLE dbname <tab><tab> to show new
RENAME TO option.

21 years agoCorrect misspellings of REFERENCES.
Tom Lane [Sat, 8 Nov 2003 20:43:57 +0000 (20:43 +0000)]
Correct misspellings of REFERENCES.

21 years agoRestore compatibility with Tcl 8.0.* --- from ljb.
Tom Lane [Sat, 8 Nov 2003 20:34:42 +0000 (20:34 +0000)]
Restore compatibility with Tcl 8.0.* --- from ljb.

21 years agoDon't need hack copy of system() anymore in OS X 10.3.
Tom Lane [Sat, 8 Nov 2003 20:14:57 +0000 (20:14 +0000)]
Don't need hack copy of system() anymore in OS X 10.3.

21 years agoFix parsing of create index call
Michael Meskes [Sat, 8 Nov 2003 19:14:20 +0000 (19:14 +0000)]
Fix parsing of create index call

21 years agoFix process-status handling for OS X 10.3.
Tom Lane [Sat, 8 Nov 2003 19:07:30 +0000 (19:07 +0000)]
Fix process-status handling for OS X 10.3.

21 years agoAdjust file so psql help picks it up properly.
Peter Eisentraut [Sat, 8 Nov 2003 11:05:40 +0000 (11:05 +0000)]
Adjust file so psql help picks it up properly.

patch by Kris Jurka

21 years agoCause stats processes to detach from shared memory when started, so that
Tom Lane [Fri, 7 Nov 2003 21:56:02 +0000 (21:56 +0000)]
Cause stats processes to detach from shared memory when started, so that
they do not prevent the postmaster from deleting the shmem segment during
a post-backend-crash restart cycle.  Per recent discussion.

21 years agozero_damaged_pages must absolutely NOT be marked GUC_DISALLOW_IN_FILE,
Tom Lane [Fri, 7 Nov 2003 21:27:50 +0000 (21:27 +0000)]
zero_damaged_pages must absolutely NOT be marked GUC_DISALLOW_IN_FILE,
else it cannot be used to handle failures detected during WAL replay.
Fortunately this flag isn't actually enforced yet, but get it right.

21 years agoMinor copy-editing.
Tom Lane [Thu, 6 Nov 2003 22:21:55 +0000 (22:21 +0000)]
Minor copy-editing.

21 years agoMake the detection of nsgmls more robust for funny shells.
Peter Eisentraut [Thu, 6 Nov 2003 10:28:54 +0000 (10:28 +0000)]
Make the detection of nsgmls more robust for funny shells.

21 years agoFix for this problem:
Tom Lane [Wed, 5 Nov 2003 22:00:52 +0000 (22:00 +0000)]
Fix for this problem:

regression=# select 1 from tenk1 ta cross join tenk1 tb for update;
ERROR:  no relation entry for relid 3

7.3 said "SELECT FOR UPDATE cannot be applied to a join", which was better
but still wrong, considering that 7.2 took the query just fine.  Fix by
making transformForUpdate() ignore JOIN and other special RTE types,
rather than trying to mark them FOR UPDATE.  The actual error message now
only appears if you explicitly name the join in FOR UPDATE.

21 years agoAdd -O to really trigger compiler bug.
Peter Eisentraut [Wed, 5 Nov 2003 07:42:18 +0000 (07:42 +0000)]
Add -O to really trigger compiler bug.

21 years agoCheck off UnixWare.
Peter Eisentraut [Wed, 5 Nov 2003 00:13:21 +0000 (00:13 +0000)]
Check off UnixWare.

21 years agoAdd detection of compiler bug.
Peter Eisentraut [Wed, 5 Nov 2003 00:09:25 +0000 (00:09 +0000)]
Add detection of compiler bug.

21 years agoMinor copy-editing.
Tom Lane [Wed, 5 Nov 2003 00:05:37 +0000 (00:05 +0000)]
Minor copy-editing.

21 years agoSome copy-editing for 7.4 release notes.
Tom Lane [Tue, 4 Nov 2003 20:54:20 +0000 (20:54 +0000)]
Some copy-editing for 7.4 release notes.

21 years agoGive the full syntax rules for subscripting and field selection in the
Tom Lane [Tue, 4 Nov 2003 19:18:23 +0000 (19:18 +0000)]
Give the full syntax rules for subscripting and field selection in the
proper place, namely the syntax discussion of value expressions.

21 years agoUpdate keywords table.
Peter Eisentraut [Tue, 4 Nov 2003 12:59:21 +0000 (12:59 +0000)]
Update keywords table.

21 years agoRemove unused graphics files.
Peter Eisentraut [Tue, 4 Nov 2003 10:25:11 +0000 (10:25 +0000)]
Remove unused graphics files.

21 years agoAdd report about HP-UX 11.00.
Peter Eisentraut [Tue, 4 Nov 2003 10:08:57 +0000 (10:08 +0000)]
Add report about HP-UX 11.00.

21 years agoRandom copy-editing.
Peter Eisentraut [Tue, 4 Nov 2003 09:45:30 +0000 (09:45 +0000)]
Random copy-editing.

21 years agoImprove wording of spinlocks-missing compilation error message.
Peter Eisentraut [Tue, 4 Nov 2003 09:43:56 +0000 (09:43 +0000)]
Improve wording of spinlocks-missing compilation error message.

21 years agoMake sure bug fix makes it into 7.4 as well. Thanks Peter.
Michael Meskes [Tue, 4 Nov 2003 08:45:47 +0000 (08:45 +0000)]
Make sure bug fix makes it into 7.4 as well. Thanks Peter.

21 years agofix typo. (role_columns_grants -> role_column_grants)
Tatsuo Ishii [Tue, 4 Nov 2003 05:43:33 +0000 (05:43 +0000)]
fix typo. (role_columns_grants -> role_column_grants)

21 years agoCopy-editing.
Tom Lane [Tue, 4 Nov 2003 00:34:50 +0000 (00:34 +0000)]
Copy-editing.

21 years agotag it Release Candidate 1, as previously discussed REL7_4_RC1
PostgreSQL Daemon [Mon, 3 Nov 2003 05:27:18 +0000 (05:27 +0000)]
tag it Release Candidate 1, as previously discussed

21 years agoAdjust data types in some of the UNION tests to avoid potentially
Tom Lane [Sun, 2 Nov 2003 22:35:26 +0000 (22:35 +0000)]
Adjust data types in some of the UNION tests to avoid potentially
platform-dependent results, as per example from Larry Rosenman.

21 years agoProvide a way to run the parallel regression tests with a user-specified
Tom Lane [Sun, 2 Nov 2003 21:56:15 +0000 (21:56 +0000)]
Provide a way to run the parallel regression tests with a user-specified
limit on the number of simultaneous connections.  Andrew Dunstan, with
review by Tom Lane.

21 years agoFix language.
Peter Eisentraut [Sun, 2 Nov 2003 12:59:54 +0000 (12:59 +0000)]
Fix language.

21 years agoMake spelling consistent.
Peter Eisentraut [Sun, 2 Nov 2003 12:59:28 +0000 (12:59 +0000)]
Make spelling consistent.

21 years agopg_dumpall doesn't use psql anymore.
Peter Eisentraut [Sun, 2 Nov 2003 12:58:39 +0000 (12:58 +0000)]
pg_dumpall doesn't use psql anymore.

21 years agoPut --describe-config in the right place.
Peter Eisentraut [Sun, 2 Nov 2003 12:58:11 +0000 (12:58 +0000)]
Put --describe-config in the right place.

21 years agoFix name in supported platforms list.
Peter Eisentraut [Sun, 2 Nov 2003 12:57:48 +0000 (12:57 +0000)]
Fix name in supported platforms list.

21 years agoComplete options help and put it in less random order.
Peter Eisentraut [Sun, 2 Nov 2003 12:55:24 +0000 (12:55 +0000)]
Complete options help and put it in less random order.

21 years agoCall domains "domains", not "derived types".
Peter Eisentraut [Sun, 2 Nov 2003 12:53:57 +0000 (12:53 +0000)]
Call domains "domains", not "derived types".

21 years agoUpdate ports list.
Peter Eisentraut [Sun, 2 Nov 2003 08:54:09 +0000 (08:54 +0000)]
Update ports list.

21 years agoUnset CFLAGS before reading template. This should be more robust.
Peter Eisentraut [Sat, 1 Nov 2003 20:48:51 +0000 (20:48 +0000)]
Unset CFLAGS before reading template.  This should be more robust.

When --enable-debug is used, then the default CFLAGS for non-GCC is just
-g without -O.

Backpatch enhancement of Autoconf inline test that detects problems with
the HP C compiler.

21 years agoFix CFLAGS logic.
Peter Eisentraut [Sat, 1 Nov 2003 20:45:30 +0000 (20:45 +0000)]
Fix CFLAGS logic.

21 years agoMore whitespace fixes. Do people write the expected files by hand?
Peter Eisentraut [Sat, 1 Nov 2003 03:18:20 +0000 (03:18 +0000)]
More whitespace fixes.  Do people write the expected files by hand?

21 years agoFix hidden whitespace differences between expected and result files.
Peter Eisentraut [Sat, 1 Nov 2003 03:07:07 +0000 (03:07 +0000)]
Fix hidden whitespace differences between expected and result files.

21 years agoSpell checking, consistent terminology.
Peter Eisentraut [Sat, 1 Nov 2003 01:56:29 +0000 (01:56 +0000)]
Spell checking, consistent terminology.

21 years agoUpdate future-tense comments in README to present tense. Noted by
Tom Lane [Fri, 31 Oct 2003 22:48:08 +0000 (22:48 +0000)]
Update future-tense comments in README to present tense.  Noted by
Neil Conway.

21 years agoRewrite GiST documentation into something actually useful.
Tom Lane [Fri, 31 Oct 2003 22:41:21 +0000 (22:41 +0000)]
Rewrite GiST documentation into something actually useful.

Christopher Kings-Lynne

21 years agoFix broken markup.
Tom Lane [Fri, 31 Oct 2003 22:22:10 +0000 (22:22 +0000)]
Fix broken markup.

21 years agoTranslation update
Peter Eisentraut [Fri, 31 Oct 2003 22:14:15 +0000 (22:14 +0000)]
Translation update

21 years agoWhen a superuser does GRANT or REVOKE on an object he doesn't own,
Tom Lane [Fri, 31 Oct 2003 20:00:49 +0000 (20:00 +0000)]
When a superuser does GRANT or REVOKE on an object he doesn't own,
process the command as though it were issued by the object owner.
This prevents creating weird scenarios in which the same privileges
may appear to flow from different sources, and ensures that a superuser
can in fact revoke all privileges if he wants to.  In particular this
means that the regression tests work when run by a superuser other than
the original bootstrap userid.  Per report from Larry Rosenman.

21 years agonew protocol, faster startup.
Bruce Momjian [Fri, 31 Oct 2003 19:51:14 +0000 (19:51 +0000)]
new protocol, faster startup.

21 years agoUpdate for polymorphic functions, needs more work.
Bruce Momjian [Fri, 31 Oct 2003 19:49:40 +0000 (19:49 +0000)]
Update for polymorphic functions, needs more work.

21 years agoMAC OS X => Mac OS X
Bruce Momjian [Fri, 31 Oct 2003 19:33:17 +0000 (19:33 +0000)]
MAC OS X => Mac OS X

21 years agoRelease updates suggested by Tom.
Bruce Momjian [Fri, 31 Oct 2003 19:24:17 +0000 (19:24 +0000)]
Release updates suggested by Tom.

21 years agoMinor cleanup of PQunescapeBytea(). Avoid unportable assumptions about
Tom Lane [Fri, 31 Oct 2003 17:43:10 +0000 (17:43 +0000)]
Minor cleanup of PQunescapeBytea().  Avoid unportable assumptions about
behavior of malloc and realloc when request size is 0.  Fix escape
sequence recognizer so that only valid 3-digit octal sequences are
treated as escape sequences ... isdigit() is not a correct test.

21 years agoMoved the recently added test for foreign key disabled by rewrite
Jan Wieck [Fri, 31 Oct 2003 14:27:57 +0000 (14:27 +0000)]
Moved the recently added test for foreign key disabled by rewrite
rule into the rule.sql since it affects the latter if run in paralell.

Jan

21 years agoIf EOF is found inside a string/comment/etc. stop parsing.
Michael Meskes [Fri, 31 Oct 2003 14:10:41 +0000 (14:10 +0000)]
If EOF is found inside a string/comment/etc. stop parsing.

21 years agoRemove <note> take, use another paragraph for description.
Bruce Momjian [Fri, 31 Oct 2003 04:44:25 +0000 (04:44 +0000)]
Remove <note> take, use another paragraph for description.

21 years agoUpdate HISTORY.
Bruce Momjian [Fri, 31 Oct 2003 04:32:36 +0000 (04:32 +0000)]
Update HISTORY.

21 years agoUpdate with more comments.
Bruce Momjian [Fri, 31 Oct 2003 04:30:22 +0000 (04:30 +0000)]
Update with more comments.

21 years agoFix for possible referential integrity violation when a qualified ON INSERT
Jan Wieck [Fri, 31 Oct 2003 03:58:21 +0000 (03:58 +0000)]
Fix for possible referential integrity violation when a qualified ON INSERT
rule split the query into one INSERT and one UPDATE where the UPDATE
then hit's the just created row without modifying the key fields again.
In this special case, the new key slipped in totally unchecked.

Jan

21 years agoSmall fix to Christopher's recent improvements --- underscore is not
Tom Lane [Fri, 31 Oct 2003 03:58:15 +0000 (03:58 +0000)]
Small fix to Christopher's recent improvements --- underscore is not
a special character in regexes, but it is for LIKE, so NOT LIKE 'pg_%'
is incorrect.  Need NOT LIKE 'pg\_%'.

21 years agoUse Tcl ByteArray objects to avoid unwanted character set translation
Tom Lane [Fri, 31 Oct 2003 00:18:55 +0000 (00:18 +0000)]
Use Tcl ByteArray objects to avoid unwanted character set translation
in libpgtcl's lo_read/lo_write commands.  Also, deal correctly with
failure return from lo_read().  ljb and Tom Lane.

21 years agoFurther work on tab completion code: arrange for system catalogs to be
Tom Lane [Thu, 30 Oct 2003 21:37:38 +0000 (21:37 +0000)]
Further work on tab completion code: arrange for system catalogs to be
offered for completion only when the input-so-far is at least 'pg_'.
This seems to be the best compromise behavior emerging from yesterday's
discussion.  While at it, refactor code to eliminate repetitive use of
nearly identical queries, which was exceedingly tedious to maintain.
Also const-ify code more thoroughly in hopes of moving constant data into
text segment, and remove unnecessary length limit on queries.

21 years agoFix markup by using <note> for comments.
Bruce Momjian [Thu, 30 Oct 2003 20:49:47 +0000 (20:49 +0000)]
Fix markup by using <note> for comments.

21 years agoMore SGML cleanup.
Bruce Momjian [Thu, 30 Oct 2003 20:31:24 +0000 (20:31 +0000)]
More SGML cleanup.

21 years agoSGML cleanup.
Bruce Momjian [Thu, 30 Oct 2003 20:29:35 +0000 (20:29 +0000)]
SGML cleanup.

21 years agoUpdate SGML release notes with Peter's direction. Does not compile
Bruce Momjian [Thu, 30 Oct 2003 20:25:36 +0000 (20:25 +0000)]
Update SGML release notes with Peter's direction. Does not compile
because of section adjustments still needed.