[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.42&r2=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) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c?

[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 c

[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) (http://developer.postgresql.org/cvsweb.cgi/p

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.2&r2=1.3) ---(end of broadcast

[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: -- pgsq

[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) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/high-availability.s

[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.23&r2=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) (http://d

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

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.11&r2=1.12) NEWS (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsw

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 fo

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 t

[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) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_ctl-ref.

[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) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/filelist

[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.5&r2=1.6) pgsql/contrib/btree_gi

[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 m

[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.2&r2=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 (http://developer.postgresql.o