[COMMITTERS] pgsql-server: Supress warning about zero-length format string.

2004-08-07 Thread Bruce Momjian
Log Message: --- Supress warning about zero-length format string. Modified Files: -- pgsql-server/src/bin/pg_dump: pg_dumpall.c (r1.47 -> r1.48) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pg_dump/pg_dumpall.c.diff?r1=1.47&r2=1.48) ---

[COMMITTERS] pgsql-server: Allow libpgport to call memory allocation routines even

2004-08-07 Thread Bruce Momjian
Log Message: --- Allow libpgport to call memory allocation routines even though CurrentMemoryContext is DLLIMPORT on Win32. Work around that by creating stubs in the backend for palloc/pstrdup. Also fix pg_dumpall to do proper quoting on Win32. Modified Files: -- pgsql-se

[COMMITTERS] pgsql-server: Another array syntax change (whitespace) clarification --

2004-08-07 Thread Joe Conway
Log Message: --- Another array syntax change (whitespace) clarification -- this time in the release notes. Modified Files: -- pgsql-server/doc/src/sgml: release.sgml (r1.279 -> r1.280) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/re

[COMMITTERS] pgsql-server: Minor clarification of documentation regarding trailing

2004-08-07 Thread Joe Conway
Log Message: --- Minor clarification of documentation regarding trailing whitespace. Modified Files: -- pgsql-server/doc/src/sgml: array.sgml (r1.37 -> r1.38) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/array.sgml.diff?r1=1.37&r2=1

[COMMITTERS] pgsql-server: Updated release notes for recent array syntax changes.

2004-08-07 Thread Joe Conway
Log Message: --- Updated release notes for recent array syntax changes. Modified Files: -- pgsql-server/doc/src/sgml: release.sgml (r1.278 -> r1.279) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/release.sgml.diff?r1=1.278&r2=1.279)

[COMMITTERS] pgsql-server: More Win32 zic build cleanups now that we have symlinks,

2004-08-07 Thread Bruce Momjian
Log Message: --- More Win32 zic build cleanups now that we have symlinks, it needs help. Modified Files: -- pgsql-server/src/timezone: Makefile (r1.14 -> r1.15) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/timezone/Makefile.diff?r1=1.14&r2=1

[COMMITTERS] pgsql-server: Adjust defines to be consistent.

2004-08-07 Thread Bruce Momjian
Log Message: --- Adjust defines to be consistent. Modified Files: -- pgsql-server/src/port: dirmod.c (r1.16 -> r1.17) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/dirmod.c.diff?r1=1.16&r2=1.17) ---(end of broadc

[COMMITTERS] pgsql-server: Tighened up syntax checking of array input processing

2004-08-07 Thread Joe Conway
Log Message: --- Tighened up syntax checking of array input processing considerably. Junk that was previously allowed in odd places with odd results now causes an ERROR. Also changed behavior with respect to whitespace -- trailing whitespace is now ignored as well as leading whitespace (whi

[COMMITTERS] pgsql-server: Another zic cleanup .

2004-08-07 Thread Bruce Momjian
Log Message: --- Another zic cleanup . Modified Files: -- pgsql-server/src/timezone: Makefile (r1.13 -> r1.14) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/timezone/Makefile.diff?r1=1.13&r2=1.14) ---(end of broadcast

[COMMITTERS] pgsql-server: Update admin guide's discussion of WAL to match present

2004-08-07 Thread Tom Lane
Log Message: --- Update admin guide's discussion of WAL to match present reality. Modified Files: -- pgsql-server/doc/src/sgml: backup.sgml (r2.45 -> r2.46) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/backup.sgml.diff?r1=2.45&r2=2.

[COMMITTERS] pgsql-server: Link in dirmod specially for zic so it works on Win32.

2004-08-07 Thread Bruce Momjian
Log Message: --- Link in dirmod specially for zic so it works on Win32. Modified Files: -- pgsql-server/src/timezone: Makefile (r1.12 -> r1.13) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/timezone/Makefile.diff?r1=1.12&r2=1.13) ---

[COMMITTERS] pgsql-server: Remove xstrdup and friends who were only called once.

2004-08-07 Thread Bruce Momjian
Log Message: --- Remove xstrdup and friends who were only called once. Replace with #ifdef calls. Modified Files: -- pgsql-server/src/port: dirmod.c (r1.15 -> r1.16) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/dirmod.c.diff?r1=1.15&r2

[COMMITTERS] pgsql-server: Add a comment about why we always replay backup blocks

2004-08-07 Thread Tom Lane
Log Message: --- Add a comment about why we always replay backup blocks from WAL. Modified Files: -- pgsql-server/src/backend/access/transam: xlog.c (r1.156 -> r1.157) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/access/transam/xlog.

[COMMITTERS] pgsql-server: Fix Win32 pg_dumpall, with help from Claudio.

2004-08-07 Thread Bruce Momjian
Log Message: --- Fix Win32 pg_dumpall, with help from Claudio. Modified Files: -- pgsql-server/src/port: exec.c (r1.18 -> r1.19) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/exec.c.diff?r1=1.18&r2=1.19) ---(end

[COMMITTERS] pgsql-server: Improve comment.

2004-08-07 Thread Bruce Momjian
Log Message: --- Improve comment. Modified Files: -- pgsql-server/src/port: exec.c (r1.17 -> r1.18) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/port/exec.c.diff?r1=1.17&r2=1.18) ---(end of broadcast)

[COMMITTERS] pgsql-server: Minor editorialization on example --- I think that the use

2004-08-07 Thread Tom Lane
Log Message: --- Minor editorialization on example --- I think that the use of dollar quoting in this case is just needless obscurantism. Modified Files: -- pgsql-server/doc/src/sgml/ref: create_domain.sgml (r1.18 -> r1.19) (http://developer.postgresql.org/

[COMMITTERS] pgsql-server: This patch adds SQL2003 to the set of standards with which

2004-08-07 Thread Bruce Momjian
Log Message: --- This patch adds SQL2003 to the set of standards with which PostgreSQL is attempting to comply. David Fetter Modified Files: -- pgsql-server/doc/src/sgml: intro.sgml (r1.24 -> r1.25) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/

[COMMITTERS] pgsql-server: This adds a caveat to the inheritance part of the

2004-08-07 Thread Bruce Momjian
Log Message: --- This adds a caveat to the inheritance part of the tutorial. David Fetter Modified Files: -- pgsql-server/doc/src/sgml: advanced.sgml (r1.43 -> r1.44) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/advanced.sgml.diff?

[COMMITTERS] pgsql-server: This patch adds an example to the CREATE DOMAIN docs.

2004-08-07 Thread Bruce Momjian
Log Message: --- This patch adds an example to the CREATE DOMAIN docs. David Fetter Modified Files: -- pgsql-server/doc/src/sgml/ref: create_domain.sgml (r1.17 -> r1.18) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ref/create_domai

[COMMITTERS] pgsql-server: Included is an example of using savepoints in a

2004-08-07 Thread Bruce Momjian
Log Message: --- Included is an example of using savepoints in a non-trivial example. Giving examples in the SQL command reference is hard because we don't have conditionals at the SQL level. Gavin Sherry Modified Files: -- pgsql-server/doc/src/sgml/ref: begin.sgm

[COMMITTERS] pgsql-server: Fix comment.

2004-08-07 Thread Bruce Momjian
Log Message: --- Fix comment. Modified Files: -- pgsql-server/src/include: port.h (r1.48 -> r1.49) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/port.h.diff?r1=1.48&r2=1.49) ---(end of broadcast)--

[COMMITTERS] pgsql-server: Fixups for Win32 symlinks.

2004-08-07 Thread Bruce Momjian
Log Message: --- Fixups for Win32 symlinks. Modified Files: -- pgsql-server: configure (r1.381 -> r1.382) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/configure.diff?r1=1.381&r2=1.382) configure.in (r1.371 -> r1.372) (http://dev

[COMMITTERS] pgsql-server: Update plpgsql documentation for 8.0 (mostly, make use of

2004-08-07 Thread Tom Lane
Log Message: --- Update plpgsql documentation for 8.0 (mostly, make use of named function parameters and dollar quoting in examples; do some polishing of the existing dollar-quoting docs). The 'how to port from Oracle' section is looking pretty respectable these days ... Modified Files: -

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > But then again, based on this entire discussion and the fact that > unvoluntary vacuum runs during a production servers peak time are the > worst thing that can happen, I take it that it was never intended to > enable pg_autovacuum by default either and th

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Jan Wieck
On 8/7/2004 2:06 PM, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: Just curious, but isn't this one of the key points about pg_autovacuum in the first place? So that you vacuum what needs to be vacuum'd, and not *everything* ... ? Shouldn't the answer to the 'bandwidth issue' c

[COMMITTERS] pgsql-server: The attached patch implements a symlink for win32 using

2004-08-07 Thread Bruce Momjian
Log Message: --- The attached patch implements a symlink for win32 using junctions, and uses that for win32 tablespaces. Andreas Pflug Modified Files: -- pgsql-server/src/include: port.h (r1.47 -> r1.48) (http://developer.postgresql.org/cvsweb.cgi/pgsql-se

[COMMITTERS] pgsql-server: Improve privileges discussion (mostly, mention grant

2004-08-07 Thread Tom Lane
Log Message: --- Improve privileges discussion (mostly, mention grant options). Modified Files: -- pgsql-server/doc/src/sgml: ddl.sgml (r1.28 -> r1.29) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ddl.sgml.diff?r1=1.28&r2=1.29)

[COMMITTERS] pgsql-server: Update a couple of example error messages to reflect the

2004-08-07 Thread Tom Lane
Log Message: --- Update a couple of example error messages to reflect the fact that we don't generate constraint names like "$1" anymore. Modified Files: -- pgsql-server/doc/src/sgml: advanced.sgml (r1.42 -> r1.43) (http://developer.postgresql.org/cvsweb.cg

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Bruce Momjian
Jan Wieck wrote: > On 8/7/2004 12:47 AM, Tom Lane wrote: > > > [EMAIL PROTECTED] (Jan Wieck) writes: > >> Vacuum delay activated by default. > > > > What? If there was consensus to do this, I missed it. If there was > > even any *discussion* of doing this, I missed it. > > > >

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > how about having it as part of the SQL? > VACUUM ANALYZE DELAY; Offhand I don't see any advantage to doing it that way... regards, tom lane ---(end of broadcast)--- TIP 4: Do

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Marc G. Fournier
On Sat, 7 Aug 2004, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: Just curious, but isn't this one of the key points about pg_autovacuum in the first place? So that you vacuum what needs to be vacuum'd, and not *everything* ... ? Shouldn't the answer to the 'bandwidth issue' chan

[COMMITTERS] pgsql-server: Improve markup a little.

2004-08-07 Thread Tom Lane
Log Message: --- Improve markup a little. Modified Files: -- pgsql-server/doc/src/sgml: manage-ag.sgml (r2.32 -> r2.33) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/manage-ag.sgml.diff?r1=2.32&r2=2.33) ---(e

[COMMITTERS] pgsql-server: Improve tablespace discussion, and bring it up to date

2004-08-07 Thread Tom Lane
Log Message: --- Improve tablespace discussion, and bring it up to date with code. Modified Files: -- pgsql-server/doc/src/sgml: manage-ag.sgml (r2.31 -> r2.32) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/manage-ag.sgml.diff?r1=2.3

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Joe Conway
Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: Just curious, but isn't this one of the key points about pg_autovacuum in the first place? So that you vacuum what needs to be vacuum'd, and not *everything* ... ? Shouldn't the answer to the 'bandwidth issue' change to 'you should

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Jan Wieck
On 8/7/2004 12:47 AM, Tom Lane wrote: [EMAIL PROTECTED] (Jan Wieck) writes: Vacuum delay activated by default. What? If there was consensus to do this, I missed it. If there was even any *discussion* of doing this, I missed it. regards, tom lane How many questions about vacuum still grabbing a

[COMMITTERS] pgsql-server: Update pitr docs to mention inclusive/exclusive xid

2004-08-07 Thread Bruce Momjian
Log Message: --- Update pitr docs to mention inclusive/exclusive xid specification Modified Files: -- pgsql-server/doc/src/sgml: backup.sgml (r2.44 -> r2.45) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/backup.sgml.diff?r1=2.44&r2=2

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > Just curious, but isn't this one of the key points about pg_autovacuum in > the first place? So that you vacuum what needs to be vacuum'd, and not > *everything* ... ? Shouldn't the answer to the 'bandwidth issue' change > to 'you should install

[COMMITTERS] pgsql-server: Remove bogus trailing dot from eventlog output, per

2004-08-07 Thread Tom Lane
Log Message: --- Remove bogus trailing dot from eventlog output, per Andreas. Clean up README file a bit. Modified Files: -- pgsql-server/src/bin/pgevent: MSG1.bin (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/bin/pgevent/M

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Marc G. Fournier
On Sat, 7 Aug 2004, Bruce Momjian wrote: Marc G. Fournier wrote: On Sat, 7 Aug 2004, Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: On 8/7/2004 12:47 AM, Tom Lane wrote: What? If there was consensus to do this, I missed it. If there was even any *discussion* of doing this, I missed it. Ho

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Bruce Momjian
Marc G. Fournier wrote: > On Sat, 7 Aug 2004, Tom Lane wrote: > > > Jan Wieck <[EMAIL PROTECTED]> writes: > >> On 8/7/2004 12:47 AM, Tom Lane wrote: > >>> What? If there was consensus to do this, I missed it. If there was > >>> even any *discussion* of doing this, I missed it. > > > >> How many

[COMMITTERS] pgsql-server: Don't try to rewrite NEW references in a utility statement

2004-08-07 Thread Tom Lane
Log Message: --- Don't try to rewrite NEW references in a utility statement in a rule. There won't be any, and in fact there won't even be an RTE for NEW, which was leading to a core dump in CVS tip. 7.4 and earlier manage not to crash when applying ResolveNew in this scenario, but I think

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Marc G. Fournier
On Sat, 7 Aug 2004, Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: On 8/7/2004 12:47 AM, Tom Lane wrote: What? If there was consensus to do this, I missed it. If there was even any *discussion* of doing this, I missed it. How many questions about vacuum still grabbing all available bandwi

Re: [COMMITTERS] pgsql-server: Vacuum delay activated by default.

2004-08-07 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > On 8/7/2004 12:47 AM, Tom Lane wrote: >> What? If there was consensus to do this, I missed it. If there was >> even any *discussion* of doing this, I missed it. > How many questions about vacuum still grabbing all available bandwidth, > vacuum slowing dow

[COMMITTERS] pgsql-server: Fix markup.

2004-08-07 Thread Bruce Momjian
Log Message: --- Fix markup. Modified Files: -- pgsql-server/doc/src/sgml: backup.sgml (r2.43 -> r2.44) (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/backup.sgml.diff?r1=2.43&r2=2.44) ---(end of broadcast)---