[COMMITTERS] pgsql: Fix broken markup.

2007-01-31 Thread Neil Conway
Log Message: --- Fix broken markup. Modified Files: -- pgsql/doc/src/sgml: release.sgml (r1.494 -> r1.495) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.494&r2=1.495) ---(end of broadcast)

[COMMITTERS] pgsql: Add 8.2.0 "Incomatibilities" documentation that pg_dump's -n and

2007-01-31 Thread Bruce Momjian
Log Message: --- Add 8.2.0 "Incomatibilities" documentation that pg_dump's -n and -t behavior has changed. Modified Files: -- pgsql/doc/src/sgml: release.sgml (r1.493 -> r1.494) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.dif

[COMMITTERS] pgsql: Add 8.2.0 "Incomatibilities" documentation that pg_dump's -n and

2007-01-31 Thread Bruce Momjian
Log Message: --- Add 8.2.0 "Incomatibilities" documentation that pg_dump's -n and -t behavior has changed. Tags: REL8_2_STABLE Modified Files: -- pgsql/doc/src/sgml: release.sgml (r1.488.2.2 -> r1.488.2.3) (http://developer.postgresql.org/cvsweb.cgi/p

[COMMITTERS] pgsql: Backpatch FAQs to stable branch.

2007-01-31 Thread Bruce Momjian
Log Message: --- Backpatch FAQs to stable branch. Tags: REL8_2_STABLE Modified Files: -- pgsql/doc: FAQ (r1.402.2.3 -> r1.402.2.4) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.402.2.3&r2=1.402.2.4) FAQ_AIX (r1.19.2.3 ->

[COMMITTERS] pgsql: Chinese FAQ update Daojing.Zhou

2007-01-31 Thread Bruce Momjian
Log Message: --- Chinese FAQ update Daojing.Zhou Modified Files: -- pgsql/doc: FAQ_chinese (r1.5 -> r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_chinese.diff?r1=1.5&r2=1.6) pgsql/doc/src/FAQ: FAQ_chinese.html (r1.10 -> r1.11)

[COMMITTERS] pgsql: Update URL for function permission checks

2007-01-31 Thread Bruce Momjian
Log Message: --- Update URL for function permission checks < http://archives.postgresql.org/pgsql-hackers/2006-12/msg00564.php > http://archives.postgresql.org/pgsql-hackers/2006-12/msg00568.php > Modified Files: -- pgsql/doc: TODO (r1.2063 -> r1.2064)

[COMMITTERS] pgsql: Add: > > * Tighten function permission checks > >

2007-01-31 Thread Bruce Momjian
Log Message: --- Add: > > * Tighten function permission checks > > http://archives.postgresql.org/pgsql-hackers/2006-12/msg00564.php > Modified Files: -- pgsql/doc: TODO (r1.2062 -> r1.2063) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.di

[COMMITTERS] pgsql: Add: > > * Tighten trigger permission checks > >

2007-01-31 Thread Bruce Momjian
Log Message: --- Add: > > * Tighten trigger permission checks > > http://archives.postgresql.org/pgsql-hackers/2006-12/msg00564.php > Modified Files: -- pgsql/doc: TODO (r1.2061 -> r1.2062) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.dif

[COMMITTERS] pgsql: This patch adds documentation for the long-version parameters

2007-01-31 Thread Neil Conway
Log Message: --- This patch adds documentation for the long-version parameters --username and --password for pg_dump, pg_dumpall and pg_restore, per complaint by Michael Schmidt. Patch from Magnus Hagander. Modified Files: -- pgsql/doc/src/sgml/ref: pg_dump.sgml (r1

[COMMITTERS] pgsql: Add: > > * Fix problem when multiple subtransactions of the same

2007-01-31 Thread Bruce Momjian
Log Message: --- Add: > > * Fix problem when multiple subtransactions of the same outer transaction > hold different types of locks, and one subtransaction aborts > > http://archives.postgresql.org/pgsql-hackers/2006-11/msg01011.php > http://archives.postgresql.org/pgsql-hackers/200

[COMMITTERS] pgsql: Fix a few typos in comments in GiN.

2007-01-31 Thread Neil Conway
Log Message: --- Fix a few typos in comments in GiN. Modified Files: -- pgsql/src/backend/access/gin: ginbtree.c (r1.7 -> r1.8) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gin/ginbtree.c.diff?r1=1.7&r2=1.8) ginbulk.c (r1.8 -

[COMMITTERS] pgsql: Update CREATE SEQUENCE documentation to show the same sequence

2007-01-31 Thread Bruce Momjian
Log Message: --- Update CREATE SEQUENCE documentation to show the same sequence being created and increments. The old docs created the sequence, then showed a nextval() of 114. Modified Files: -- pgsql/doc/src/sgml/ref: create_sequence.sgml (r1.47 -> r1.48)

[COMMITTERS] pgsql: Add URL for: o Fix RENAME to work on variables other than

2007-01-31 Thread Bruce Momjian
Log Message: --- Add URL for: o Fix RENAME to work on variables other than OLD/NEW > http://archives.postgresql.org/pgsql-hackers/2007-01/msg01615.php Modified Files: -- pgsql/doc: TODO (r1.2059 -> r1.2060) (http://developer.postgresql.org/cvsw

[COMMITTERS] pgsql: Consistenly use colons before '' blocks, where

2007-01-31 Thread Bruce Momjian
Log Message: --- Consistenly use colons before '' blocks, where appropriate. Modified Files: -- pgsql/doc/src/sgml: advanced.sgml (r1.53 -> r1.54) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/advanced.sgml.diff?r1=1.53&r2=1.54) arr

[COMMITTERS] pgsql: Update reference documentation on may/can/might: Standard

2007-01-31 Thread Bruce Momjian
Log Message: --- Update reference documentation on may/can/might: Standard English uses "may", "can", and "might" in different ways: may - permission, "You may borrow my rake." can - ability, "I can lift that log." might - possibility, "It might rain today." Unf

[COMMITTERS] pgsql: Update comment.

2007-01-31 Thread Bruce Momjian
Log Message: --- Update comment. Modified Files: -- pgsql/src/tools: pgcvslog (r1.32 -> r1.33) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/pgcvslog.diff?r1=1.32&r2=1.33) ---(end of broadcast)-

[COMMITTERS] pg-migrator - src: Recognizing 8.2 pg_resetxlog, commenting Makefile a

2007-01-31 Thread User Korryd
Log Message: --- Recognizing 8.2 pg_resetxlog, commenting Makefile a bit Modified Files: -- src: Makefile (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pg-migrator/src/Makefile.diff?r1=1.2&r2=1.3) pg_migrator.c (r1.2 -> r1.3)

[COMMITTERS] pgsql: Revert error message change for may/can/might --- needs

2007-01-31 Thread Bruce Momjian
Log Message: --- Revert error message change for may/can/might --- needs discussion. Modified Files: -- pgsql/doc/src/sgml: sources.sgml (r2.21 -> r2.22) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/sources.sgml.diff?r1=2.21&r2=2.22)

[COMMITTERS] pgsql: Update documentation on may/can/might: Standard English uses

2007-01-31 Thread Bruce Momjian
Log Message: --- Update documentation on may/can/might: Standard English uses "may", "can", and "might" in different ways: may - permission, "You may borrow my rake." can - ability, "I can lift that log." might - possibility, "It might rain today." Unfortunately

Re: [COMMITTERS] pgsql: Rewrite uuid input and output routines to avoid dependency on the

2007-01-31 Thread Tom Lane
[EMAIL PROTECTED] (Neil Conway) writes: > Rewrite uuid input and output routines to avoid dependency on the > nonportable "hh" sprintf(3) length modifier. Works for me now. Thanks. regards, tom lane ---(end of broadcast)---

[COMMITTERS] pgsql: Add missing Makefile dependencies for the "bigtest" and

2007-01-31 Thread Neil Conway
Log Message: --- Add missing Makefile dependencies for the "bigtest" and "bigcheck" targets, and refactor the tablespace setup code into a separate Makefile target. Modified Files: -- pgsql/src/test/regress: GNUmakefile (r1.64 -> r1.65) (http://developer.po

[COMMITTERS] pgsql: Rewrite uuid input and output routines to avoid dependency on the

2007-01-31 Thread Neil Conway
Log Message: --- Rewrite uuid input and output routines to avoid dependency on the nonportable "hh" sprintf(3) length modifier. Instead, do the parsing and output by hand. The code to do this isn't ideal, but this is an interim measure anyway: the uuid type should probably use the in-memory

[COMMITTERS] pgsql: Fix initdb to not generate misleading error messages when

2007-01-31 Thread Tom Lane
Log Message: --- Fix initdb to not generate misleading error messages when postgres.bki or other share-directory files are inaccessible for some reason other than not existing. Inspired by trouble report from Simon Kinsella. Modified Files: -- pgsql/src/bin/initdb:

[COMMITTERS] pgsql: Revert gincostestimate changes.

2007-01-31 Thread Teodor Sigaev
Log Message: --- Revert gincostestimate changes. Modified Files: -- pgsql/src/backend/utils/adt: selfuncs.c (r1.224 -> r1.225) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.224&r2=1.225) --

Re: [COMMITTERS] pgsql: Allow GIN's extractQuery method to signal that nothing can

2007-01-31 Thread Teodor Sigaev
If you're going to support operators that could allow every tuple to Right now it's a 'contains', 'contained by' operations for arrays. match, then I think you had better find a way to allow a full index scan within GIN. Because the above does not fix the problem, it's only a very crude band-

Re: [COMMITTERS] pgsql: Allow GIN's extractQuery method to signal that nothing can

2007-01-31 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: > amcanmulticol doesn't resolve issue, because restriction clause might > present, > but it might have not any actual values ( void tsquery, void array ) and > semantic meaning of void query might be a 'any tuple matches'. Suggested > gincostestimation'

Re: [COMMITTERS] pgsql: Allow GIN's extractQuery method to signal that nothing can

2007-01-31 Thread Teodor Sigaev
(a) it does not work (you cannot positively guarantee a plan will not be chosen just by setting its cost high) and (b) it is unnecessary. pg_am.amoptionalkey = false is the right way, and you already have that. From docs: > When amcanmulticol is false, amoptionalkey essentially says whether

Re: [COMMITTERS] pgsql: Allow GIN's extractQuery method to signal that nothing can

2007-01-31 Thread Tom Lane
[EMAIL PROTECTED] (Teodor Sigaev) writes: > Log Message: > --- > Allow GIN's extractQuery method to signal that nothing can satisfy the query. > In this case extractQuery should returns -1 as nentries. This changes > prototype of extractQuery method to use int32* instead of uint32* for > ne

[COMMITTERS] pgsql: Update FreeBSD DocBook installation notices

2007-01-31 Thread Teodor Sigaev
Log Message: --- Update FreeBSD DocBook installation notices Modified Files: -- pgsql/doc/src/sgml: docguide.sgml (r1.67 -> r1.68) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/docguide.sgml.diff?r1=1.67&r2=1.68) --

[COMMITTERS] pgsql: Allow GIN's extractQuery method to signal that nothing can

2007-01-31 Thread Teodor Sigaev
Log Message: --- Allow GIN's extractQuery method to signal that nothing can satisfy the query. In this case extractQuery should returns -1 as nentries. This changes prototype of extractQuery method to use int32* instead of uint32* for nentries argument. Based on that gincostestimate may see

[COMMITTERS] pgsql: Translation updates

2007-01-31 Thread Peter Eisentraut
Log Message: --- Translation updates Tags: REL8_2_STABLE Modified Files: -- pgsql/src/backend/po: cs.po (r1.4 -> r1.4.2.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/po/cs.po.diff?r1=1.4&r2=1.4.2.1) de.po (r1.25 -> r1.25.2.1

[COMMITTERS] pgsql: Translation updates

2007-01-31 Thread Peter Eisentraut
Log Message: --- Translation updates Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/po: de.po (r1.21.2.1 -> r1.21.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/po/de.po.diff?r1=1.21.2.1&r2=1.21.2.2) fr.po (r1.10.

[COMMITTERS] pgsql: Translation updates

2007-01-31 Thread Peter Eisentraut
Log Message: --- Translation updates Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/po: de.po (r1.19 -> r1.19.4.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/po/de.po.diff?r1=1.19&r2=1.19.4.1) fr.po (r1.7.4.4 -> r1

[COMMITTERS] pgsql: Translation updates

2007-01-31 Thread Peter Eisentraut
Log Message: --- Translation updates Tags: REL7_4_STABLE Modified Files: -- pgsql/src/backend/po: de.po (r1.11.2.4 -> r1.11.2.5) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/po/de.po.diff?r1=1.11.2.4&r2=1.11.2.5) fr.po (r1.1.2

[COMMITTERS] pgsql: Translation updates

2007-01-31 Thread Peter Eisentraut
Log Message: --- Translation updates Tags: REL7_3_STABLE Modified Files: -- pgsql/src/bin/pg_dump/po: de.po (r1.2.2.2 -> r1.2.2.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/po/de.po.diff?r1=1.2.2.2&r2=1.2.2.3) pgsql/src/int