[COMMITTERS] pgsql: Suppress compiler warning, and not incidentally make the code

2008-07-17 Thread Tom Lane
Log Message: --- Suppress compiler warning, and not incidentally make the code more robust. The previous coding was quite risky because it was testing conditions different from 'is the array really allocated?'. Modified Files: -- pgsql/src/bin/psql: describe.c (r1.

Re: [COMMITTERS] pgsql: Support "variadic" functions, which can accept a variable number

2008-07-17 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > I think CREATE FUNCTION should specifically mention that VARIADIC can > only be used as the arg mode of the last parameter. Other pages mention > this, but the syntax doesn't, which could confuse people. Like me, who > started with the CREATE FUNCTION page,

[COMMITTERS] pgsql: Implement SQL-spec RETURNS TABLE syntax for functions.

2008-07-17 Thread Tom Lane
Log Message: --- Implement SQL-spec RETURNS TABLE syntax for functions. (Unlike the original submission, this patch treats TABLE output parameters as being entirely equivalent to OUT parameters -- tgl) Pavel Stehule Modified Files: -- pgsql/doc/src/sgml: catalogs.

Re: [COMMITTERS] pgsql: Allow TRUNCATE foo, foo to succeed, per report from Nikhils.

2008-07-17 Thread Bruce Momjian
Simon Riggs wrote: > > Huh? There was a bug report, with suggested fix on June 5th from > > Nikhil - http://archives.postgresql.org/pgsql-hackers/2008-06/msg00231.php > > > > No-one responded, and over a month later Bruce fixed the bug, pointing > > out that TRUNCATE is now consistent with LOCK. >

[COMMITTERS] pgsql: Add URL for: * Implement SQL:2003 window functions >

2008-07-17 Thread Bruce Momjian
Log Message: --- Add URL for: * Implement SQL:2003 window functions > http://archives.postgresql.org/pgsql-hackers/2008-07/msg00232.php Modified Files: -- pgsql/doc: TODO (r1.2491 -> r1.2492) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1

[COMMITTERS] pgsql: Add MSVC++ debug libraries to .cvsignore.

2008-07-17 Thread Alvaro Herrera
Log Message: --- Add MSVC++ debug libraries to .cvsignore. Tags: REL8_3_STABLE Modified Files: -- pgsql/src/interfaces/ecpg/compatlib: .cvsignore (r1.1 -> r1.1.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/compatlib/.cvsigno

[COMMITTERS] pgsql: Add MSVC++ debug libraries to .cvsignore.

2008-07-17 Thread Alvaro Herrera
Log Message: --- Add MSVC++ debug libraries to .cvsignore. Modified Files: -- pgsql/src/interfaces/ecpg/compatlib: .cvsignore (r1.1 -> r1.2) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/compatlib/.cvsignore?r1=1.1&r2=1.2) pgsql/sr

[COMMITTERS] pgsql: Avoid crashing when a table is deleted while we're on the process

2008-07-17 Thread Alvaro Herrera
Log Message: --- Avoid crashing when a table is deleted while we're on the process of checking it. This is a stripped down version of the patch applied to HEAD. Per report from Tom Lane based on buildfarm evidence. Tags: REL8_3_STABLE Modified Files: -- pgsql/src/ba

[COMMITTERS] pgsql: Avoid crashing when a table is deleted while we're on the process

2008-07-17 Thread Alvaro Herrera
Log Message: --- Avoid crashing when a table is deleted while we're on the process of checking it. Per report from Tom Lane based on buildfarm evidence. Modified Files: -- pgsql/src/backend/postmaster: autovacuum.c (r1.80 -> r1.81) (http://anoncvs.postgres

[COMMITTERS] pgsql: Add dump support for SortBy nodes.

2008-07-17 Thread Tom Lane
Log Message: --- Add dump support for SortBy nodes. Needed this while debugging a reported problem with DISTINCT, so might as well commit it. Modified Files: -- pgsql/src/backend/nodes: outfuncs.c (r1.327 -> r1.328) (http://anoncvs.postgresql.org/cvsweb.cg

[COMMITTERS] pgscript - pgScript: autofind and autoclean scripts

2008-07-17 Thread User Pgunittest
Log Message: --- autofind and autoclean scripts Modified Files: -- pgScript/lib/pgscript/expressions: .cvsignore (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgscript/pgScript/lib/pgscript/expressions/.cvsignore.diff?r1=1.1&r2=1.2) pgScri

[COMMITTERS] pgscript - pgScript: Replacing Makefiles and configures

2008-07-17 Thread User Pgunittest
Log Message: --- Replacing Makefiles and configures Modified Files: -- pgScript/lib: pgadmin.sh (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgscript/pgScript/lib/pgadmin.sh.diff?r1=1.3&r2=1.4) Added Files: --- pgScript/test:

[COMMITTERS] pgscript - pgScript: pgAdmin export script

2008-07-17 Thread User Pgunittest
Log Message: --- pgAdmin export script Modified Files: -- pgScript/lib: pgadmin.sh (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgscript/pgScript/lib/pgadmin.sh.diff?r1=1.2&r2=1.3) -- Sent via pgsql-committers mailing list (pgsql-committers

Re: [COMMITTERS] pgsql: Allow TRUNCATE foo, foo to succeed, per report from Nikhils.

2008-07-17 Thread Simon Riggs
On Thu, 2008-07-17 at 09:00 +0100, Dave Page wrote: > On Thu, Jul 17, 2008 at 8:48 AM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > > > On Thu, 2008-07-17 at 11:16 +0530, Nikhils wrote: > > > > > >> I presented a simple psql version here. I was actually processing > >> multiple relations in my C lib

Re: [COMMITTERS] pgsql: Allow TRUNCATE foo, foo to succeed, per report from Nikhils.

2008-07-17 Thread Dave Page
On Thu, Jul 17, 2008 at 8:48 AM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > On Thu, 2008-07-17 at 11:16 +0530, Nikhils wrote: > > >> I presented a simple psql version here. I was actually processing >> multiple relations in my C library in which truncate was invoked on >> all the involved relations

Re: [COMMITTERS] pgsql: Allow TRUNCATE foo, foo to succeed, per report from Nikhils.

2008-07-17 Thread Simon Riggs
On Thu, 2008-07-17 at 11:16 +0530, Nikhils wrote: > I presented a simple psql version here. I was actually processing > multiple relations in my C library in which truncate was invoked on > all the involved relations. I was passing a list of these rels to > ExecuteTruncate which barfed when the