[COMMITTERS] pgsql: Fix markup problem with recent pg_ctl change.

2007-11-10 Thread Bruce Momjian
Log Message: --- Fix markup problem with recent pg_ctl change. Modified Files: -- pgsql/doc/src/sgml/ref: pg_ctl-ref.sgml (r1.42 - r1.43) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_ctl-ref.sgml?r1=1.42r2=1.43)

[COMMITTERS] pgsql: Reduce error level of ROLLBACK outside a transaction from WARNING

2007-11-10 Thread Bruce Momjian
Log Message: --- Reduce error level of ROLLBACK outside a transaction from WARNING to NOTICE. Modified Files: -- pgsql/src/backend/access/transam: xact.c (r1.251 - r1.252)

[COMMITTERS] pgsql: Have text search thesaurus files use ? for stop words.

2007-11-10 Thread Bruce Momjian
Log Message: --- Have text search thesaurus files use ? for stop words. Throw an error for actual stop words, rather than a warning. This fixes problems with cache reloading causing warning messages. Re-enable stop words in regression tests; was disabled by Tom. Document ? as API

[COMMITTERS] pgsql: Use strip -x on OS/X-darwin because non--x causes link

2007-11-10 Thread Bruce Momjian
Log Message: --- Use strip -x on OS/X-darwin because non--x causes link problems: http://archives.postgresql.org/pgsql-hackers/2007-10/msg01470.php Modified Files: -- pgsql/config: install-sh (r1.4 - r1.5)

Re: [COMMITTERS] pgsql: If an index depends on no columns of its table, give it a

2007-11-10 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: Constants in indexes are just a strangeness we don't need. I disagree. Here's an example that I don't think you can do with purely SQL-spec syntax: CREATE UNIQUE INDEX fooi ON foo ((1)) WHERE f1 0; This constrains the table to contain no more

[COMMITTERS] jdbc - CVSROOT: Attempt to point commit messages to our own mailing

2007-11-10 Thread User Jurka
Log Message: --- Attempt to point commit messages to our own mailing list. Modified Files: -- CVSROOT: loginfo (r1.2 - r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbc/CVSROOT/loginfo.diff?r1=1.2r2=1.3) ---(end of

[COMMITTERS] pgsql: xmlGetUTF8Char()'s second argument is both input and output.

2007-11-10 Thread Tom Lane
Log Message: --- xmlGetUTF8Char()'s second argument is both input and output. Fix uninitialized value, and avoid invoking the function nine separate times in the pg_xmlIsNameChar macro. Should resolve buildfarm failures. Per report from Ben Leslie. Modified Files: --

[COMMITTERS] pgsql: Update high availability documentation with comments from Markus

2007-11-10 Thread Bruce Momjian
Log Message: --- Update high availability documentation with comments from Markus Schiltknecht. Modified Files: -- pgsql/doc/src/sgml: high-availability.sgml (r1.22 - r1.23)

[COMMITTERS] pgsql: High availability wording fix.

2007-11-10 Thread Bruce Momjian
Log Message: --- High availability wording fix. Modified Files: -- pgsql/doc/src/sgml: high-availability.sgml (r1.23 - r1.24) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/high-availability.sgml?r1=1.23r2=1.24)

[COMMITTERS] pgsql: Add missing closing / in xsd:restriction, and remove some

2007-11-10 Thread Tom Lane
Log Message: --- Add missing closing / in xsd:restriction, and remove some unnecessary spaces for consistency. Per bug #3734 from Ben Leslie; fix by Euler Taveira de Oliveira. Modified Files: -- pgsql/src/backend/utils/adt: xml.c (r1.55 - r1.56)

Re: [COMMITTERS] pgsql: If an index depends on no columns of its table, give it a

2007-11-10 Thread Simon Riggs
On Sat, 2007-11-10 at 11:22 -0500, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Constants in indexes are just a strangeness we don't need. I disagree. Here's an example that I don't think you can do with purely SQL-spec syntax: CREATE UNIQUE INDEX fooi ON foo ((1)) WHERE

Re: [COMMITTERS] pgsql: If an index depends on no columns of its table, give it a

2007-11-10 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: My only fear is your reminder at a later date that we can't add feature X because of constant indexes and 8.4 is going to be all about indexes. Well, if there's actually a reason to forbid it at some point, we can reconsider. Right now there is no such

[COMMITTERS] pgsql: Add an example of a SQL function with output parameters returning

2007-11-10 Thread Tom Lane
Log Message: --- Add an example of a SQL function with output parameters returning multiple rows. I had thought this case was covered, but there was no example in the obvious section to look in. Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.129 - r1.130)

[COMMITTERS] plproxy - plproxy: relnotes for 2.0.3

2007-11-10 Thread User Mkz
Log Message: --- relnotes for 2.0.3 Modified Files: -- plproxy: Makefile (r1.11 - r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/Makefile.diff?r1=1.11r2=1.12) NEWS (r1.1 - r1.2)

Re: [COMMITTERS] pgsql: If an index depends on no columns of its table, give it a

2007-11-10 Thread David Fetter
On Sat, Nov 10, 2007 at 07:31:39PM +, Simon Riggs wrote: On Sat, 2007-11-10 at 11:22 -0500, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Constants in indexes are just a strangeness we don't need. If I invented zero-column tables You don't have to. CREATE TABLE foo();

Re: [COMMITTERS] pgsql: If an index depends on no columns of itstab le, give it a

2007-11-10 Thread Dave Page
--- Original Message --- From: David Fetter [EMAIL PROTECTED] To: Simon Riggs [EMAIL PROTECTED] Sent: 10/11/07, 20:40:15 Subject: Re: [COMMITTERS] pgsql: If an index depends on no columns of itstable, give it a If I invented zero-column tables You don't have to. CREATE

[COMMITTERS] pgsql: Add pg_ctl -t/timeout parameter to control amount of time to wait

2007-11-10 Thread Bruce Momjian
Log Message: --- Add pg_ctl -t/timeout parameter to control amount of time to wait for start/shutdown. Modified Files: -- pgsql/doc/src/sgml/ref: pg_ctl-ref.sgml (r1.43 - r1.44)

[COMMITTERS] pgsql: Move most /contrib README files into SGML.

2007-11-10 Thread Bruce Momjian
Log Message: --- Move most /contrib README files into SGML. Some still need conversion or will never be converted. Modified Files: -- pgsql/doc/src/sgml: filelist.sgml (r1.51 - r1.52)

[COMMITTERS] pgsql: Remove references to READMEs from /contrib Makefiles.

2007-11-10 Thread Bruce Momjian
Log Message: --- Remove references to READMEs from /contrib Makefiles. Modified Files: -- pgsql/contrib/adminpack: Makefile (r1.5 - r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/adminpack/Makefile?r1=1.5r2=1.6)

[COMMITTERS] pgsql: Make /contrib install/uninstall script consistent: remove

2007-11-10 Thread Bruce Momjian
Log Message: --- Make /contrib install/uninstall script consistent: remove transactions use create or replace function make formatting consistent set search patch on first line Add documentation on modifying *.sql to set the search patch, and mention that

[COMMITTERS] pgsql: Adjust pg_trgm expected output for new *.sql file.

2007-11-10 Thread Bruce Momjian
Log Message: --- Adjust pg_trgm expected output for new *.sql file. Modified Files: -- pgsql/contrib/pg_trgm/expected: pg_trgm.out (r1.2 - r1.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/expected/pg_trgm.out?r1=1.2r2=1.3)

[COMMITTERS] pgsql: Remove /contrib/dblink/doc directory, now in SGML.

2007-11-10 Thread Bruce Momjian
Log Message: --- Remove /contrib/dblink/doc directory, now in SGML. Removed Files: - pgsql/contrib/dblink/doc: connection (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/doc/connection) cursor