[COMMITTERS] libpqtypes - libpqtypes: fix escape issue inn pqt-specs man page

2008-05-09 Thread User Achernow
Log Message: --- fix escape issue inn pqt-specs man page Modified Files: -- libpqtypes: configure.ac (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/configure.ac.diff?r1=1.2&r2=1.3) libpqtypes/docs/man3: pqt-spe

[COMMITTERS] pgsql: Restore psql's former behavior that padding spaces to the right

2008-05-09 Thread Tom Lane
Log Message: --- Restore psql's former behavior that padding spaces to the right of the last output column are not emitted. (That change already caused more noise in the regression test output files than I would like.) Provide some needed editorial help for comments, clean up code formatt

[COMMITTERS] pgsql: Add URL for: o Allow an existing index to be marked as a

2008-05-09 Thread Bruce Momjian
Log Message: --- Add URL for: o Allow an existing index to be marked as a table's primary key > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg00500.php Modified Files: -- pgsql/doc: TODO (r1.2455 -> r1.2456) (http://anoncvs.pos

[COMMITTERS] pgsql: Add to TODO: > o Allow an existing index to be marked as a

2008-05-09 Thread Bruce Momjian
Log Message: --- Add to TODO: > o Allow an existing index to be marked as a table's primary key Modified Files: -- pgsql/doc: TODO (r1.2454 -> r1.2455) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2454&r2=1.2455) pgsql/doc/src/FA

[COMMITTERS] pgsql: Add URL for: * Add column to pg_stat_activity that shows the

2008-05-09 Thread Bruce Momjian
Log Message: --- Add URL for: * Add column to pg_stat_activity that shows the progress of long-running commands like CREATE INDEX and VACUUM > > http://archives.postgresql.org/pgsql-patches/2008-04/msg00203.php > Modified Files: -- pgsql/doc: TODO (r1.2453 ->

Re: [COMMITTERS] pgsql: Add regression test for various power expressions with a zero

2008-05-09 Thread Bruce Momjian
Andrew Dunstan wrote: > > Do you intend to adjust all the other float8*.out files? This test has > broken the buildfarm for quite a number of machines. Thanks, done. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.

[COMMITTERS] pgsql: Update alternative output regression files for new float8 test of

2008-05-09 Thread Bruce Momjian
Log Message: --- Update alternative output regression files for new float8 test of power(). Modified Files: -- pgsql/src/test/regress/expected: float8-exp-three-digits-win32.out (r1.8 -> r1.9) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress

Re: [COMMITTERS] pgsql: Add regression test for various power expressions with a zero

2008-05-09 Thread Andrew Dunstan
Do you intend to adjust all the other float8*.out files? This test has broken the buildfarm for quite a number of machines. cheers andrew Bruce Momjian wrote: Log Message: --- Add regression test for various power expressions with a zero base, and adjust source code to be more modul

[COMMITTERS] pgsql: Add TODO item: > o Clear table counters on TRUNCATE > >

2008-05-09 Thread Bruce Momjian
Log Message: --- Add TODO item: > o Clear table counters on TRUNCATE > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg00169.php Modified Files: -- pgsql/doc: TODO (r1.2452 -> r1.2453) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsq

[COMMITTERS] pgsql: TODOs done: > o -Prevent parent tables from altering or

2008-05-09 Thread Bruce Momjian
Log Message: --- TODOs done: > o -Prevent parent tables from altering or dropping constraints > o -Prevent child tables from altering or dropping constraints Modified Files: -- pgsql/doc: TODO (r1.2451 -> r1.2452) (http://anoncvs.postgresql.org

[COMMITTERS] pgsql: Change the rules for inherited CHECK constraints to be

2008-05-09 Thread Tom Lane
Log Message: --- Change the rules for inherited CHECK constraints to be essentially the same as those for inherited columns; that is, it's no longer allowed for a child table to not have a check constraint matching one that exists on a parent. This satisfies the principle of least surprise

[COMMITTERS] pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it

2008-05-09 Thread Tom Lane
Log Message: --- Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update varoattno along with varattno. This resulted in having Vars that were not seen as equal(), causing inheritance of the "same" constraint from different parent relations to fail. An example is c

[COMMITTERS] pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it

2008-05-09 Thread Tom Lane
Log Message: --- Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update varoattno along with varattno. This resulted in having Vars that were not seen as equal(), causing inheritance of the "same" constraint from different parent relations to fail. An example is c

[COMMITTERS] pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it

2008-05-09 Thread Tom Lane
Log Message: --- Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update varoattno along with varattno. This resulted in having Vars that were not seen as equal(), causing inheritance of the "same" constraint from different parent relations to fail. An example is c

[COMMITTERS] pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it

2008-05-09 Thread Tom Lane
Log Message: --- Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update varoattno along with varattno. This resulted in having Vars that were not seen as equal(), causing inheritance of the "same" constraint from different parent relations to fail. An example is c

[COMMITTERS] pgsql: Fix an ancient oversight in change_varattnos_of_a_node: it

2008-05-09 Thread Tom Lane
Log Message: --- Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update varoattno along with varattno. This resulted in having Vars that were not seen as equal(), causing inheritance of the "same" constraint from different parent relations to fail. An example is c

[COMMITTERS] pg-toolbox - CVSROOT: set doj's email address

2008-05-09 Thread User Doj
Log Message: --- set doj's email address Modified Files: -- CVSROOT: loginfo (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pg-toolbox/CVSROOT/loginfo.diff?r1=1.2&r2=1.3) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.

[COMMITTERS] pg-toolbox - htdocs: Imported Sources

2008-05-09 Thread User Doj
Update of /cvsroot/pg-toolbox/htdocs In directory pgfoundry.org:/tmp/cvs-serv10383 Log Message: initial import Status: Vendor Tag: cubic Release Tags: start N htdocs/index.html No conflicts created by this import -- Sent via pgsql-committers mailing list (pgsql-committ

[COMMITTERS] pg-toolbox - www: Imported Sources

2008-05-09 Thread User Doj
Update of /cvsroot/pg-toolbox/www In directory pgfoundry.org:/tmp/cvs-serv10246 Log Message: initial import Status: Vendor Tag: cubic Release Tags: start N www/index.html No conflicts created by this import -- Sent via pgsql-committers mailing list (pgsql-committers@po

[COMMITTERS] pg-toolbox - pg-toolbox: Imported Sources

2008-05-09 Thread User Doj
Update of /cvsroot/pg-toolbox/pg-toolbox In directory pgfoundry.org:/tmp/cvs-serv6641 Log Message: initial import Status: Vendor Tag: cubic Release Tags: start N pg-toolbox/pgstat N pg-toolbox/pgcomment No conflicts created by this import -- Sent via pgsql-committers m

Re: [COMMITTERS] pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

2008-05-09 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> b) If VB is 0 (zero) and VE is negative, then an exception condition is > >> raised: data exception ? invalid argument for power function. > > > Well, this indicates we shouldn't return "zero raised to a negative > > power is undefin

[COMMITTERS] pgsql: Adjust power() error messages to be more descriptive.

2008-05-09 Thread Bruce Momjian
Log Message: --- Adjust power() error messages to be more descriptive. Modified Files: -- pgsql/src/backend/utils/adt: float.c (r1.156 -> r1.157) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/float.c?r1=1.156&r2=1.157) numeri

Re: [COMMITTERS] pgsql: Improve logic for finding object files on OBJS lines in contrib

2008-05-09 Thread Andrew Dunstan
Alvaro Herrera wrote: Andrew Dunstan wrote: Log Message: --- Improve logic for finding object files on OBJS lines in contrib Makefiles. If this unbreaks buildfarm mastodon, apply everywhere. I start to wonder why don't we just implement our own make in Perl ... Had we

Re: [COMMITTERS] pgsql: Improve logic for finding object files on OBJS lines in contrib

2008-05-09 Thread Alvaro Herrera
Andrew Dunstan wrote: > Log Message: > --- > Improve logic for finding object files on OBJS lines in contrib Makefiles. If > this unbreaks buildfarm mastodon, apply everywhere. I start to wonder why don't we just implement our own make in Perl ... -- Alvaro Herrera

[COMMITTERS] pgsql: Improve logic for finding object files on OBJS lines in contrib

2008-05-09 Thread Andrew Dunstan
Log Message: --- Improve logic for finding object files on OBJS lines in contrib Makefiles. If this unbreaks buildfarm mastodon, apply everywhere. Modified Files: -- pgsql/src/tools/msvc: Mkvcbuild.pm (r1.27 -> r1.28) (http://anoncvs.postgresql.org/cvsweb.

Re: [COMMITTERS] pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

2008-05-09 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> b) If VB is 0 (zero) and VE is negative, then an exception condition is > >> raised: data exception ? invalid argument for power function. > > > Well, this indicates we shouldn't return "zero raised to a negative > > power is undefin

Re: [COMMITTERS] pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

2008-05-09 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> b) If VB is 0 (zero) and VE is negative, then an exception condition is >> raised: data exception Ñ invalid argument for power function. > Well, this indicates we shouldn't return "zero raised to a negative > power is undefined", but rather the power er

[COMMITTERS] pgsql: Give a warning if -s switch is used with a non-custom pgbench

2008-05-09 Thread Tom Lane
Log Message: --- Give a warning if -s switch is used with a non-custom pgbench test. Also, clean up the code that assigned the scale into :scale variables. Greg Smith and Tom Lane Modified Files: -- pgsql/contrib/pgbench: pgbench.c (r1.79 -> r1.80) (http://

[COMMITTERS] pgsql: Add "%option noinput" to the scanners to avoid compiler warnings.

2008-05-09 Thread Peter Eisentraut
Log Message: --- Add "%option noinput" to the scanners to avoid compiler warnings. GCC 4.3 began to realize that the input() function isn't used and printed warnings. Modified Files: -- pgsql/src/backend/bootstrap: bootscanner.l (r1.45 -> r1.46) (http://a

Re: [COMMITTERS] pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

2008-05-09 Thread Bruce Momjian
Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > Wikipedia says that exponentiation of zero to a negative power implies > > division by zero, so shouldn't we throw a "division by zero" error? > > I think it should be a specific message like "zero raised to a negative > power is undefi

[COMMITTERS] pgsql: Update C comments to mention SQL:2003 handling of power return

2008-05-09 Thread Bruce Momjian
Log Message: --- Update C comments to mention SQL:2003 handling of power return values. Modified Files: -- pgsql/src/backend/utils/adt: float.c (r1.155 -> r1.156) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/float.c?r1=1.155&r2=1.15

[COMMITTERS] pgsql: Fix Assert introduced in previous patch.

2008-05-09 Thread Heikki Linnakangas
Log Message: --- Fix Assert introduced in previous patch. Tags: REL8_3_STABLE Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.292.2.2 -> r1.292.2.3) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1

[COMMITTERS] pgsql: Fix Assert introduced in previous patch.

2008-05-09 Thread Heikki Linnakangas
Log Message: --- Fix Assert introduced in previous patch. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.301 -> r1.302) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.301&r2=1.302) -- Sent via pgsql

Re: [COMMITTERS] pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

2008-05-09 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > Wikipedia says that exponentiation of zero to a negative power implies > division by zero, so shouldn't we throw a "division by zero" error? I think it should be a specific message like "zero raised to a negative power is undefined". It's not like it's go

[COMMITTERS] pgsql: Fix incorrect archive truncation point calculation in the %r

2008-05-09 Thread Heikki Linnakangas
Log Message: --- Fix incorrect archive truncation point calculation in the %r recovery_command parameter. This fixes bug 4137 reported by Wojciech Strzalka, where a WAL file is deleted too early when starting the recovery of a warm standby server. Also add a sanity check in pg_standby so t

[COMMITTERS] pgsql: Fix incorrect archive truncation point calculation in the %r

2008-05-09 Thread Heikki Linnakangas
Log Message: --- Fix incorrect archive truncation point calculation in the %r recovery_command parameter. This fixes bug 4137 reported by Wojciech Strzalka, where a WAL file is deleted too early when starting the recovery of a warm standby server. Also add a sanity check in pg_standby so t

[COMMITTERS] libpqtypes - libpqtypes: added stdarg.h to libpqtypes.h and remove it

2008-05-09 Thread User Achernow
Log Message: --- added stdarg.h to libpqtypes.h and remove it from libpqtypes-int.h Modified Files: -- libpqtypes/src: libpqtypes-int.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/src/libpqtypes-int.h.diff?r1=1.3&r2=1.4

[COMMITTERS] libpqtypes - libpqtypes: added docs at top of error.c

2008-05-09 Thread User Achernow
Log Message: --- added docs at top of error.c Modified Files: -- libpqtypes/src: error.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/src/error.c.diff?r1=1.3&r2=1.4) -- Sent via pgsql-committers mailing list (pgsql-com

[COMMITTERS] libpqtypes - libpqtypes: added source file name and small description at

2008-05-09 Thread User Achernow
Log Message: --- added source file name and small description at top of every file Modified Files: -- libpqtypes/src: array.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/src/array.c.diff?r1=1.2&r2=1.3) datetime.

Re: [COMMITTERS] pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

2008-05-09 Thread Simon Riggs
On Thu, 2008-05-08 at 18:34 -0400, Bruce Momjian wrote: > Tom Lane wrote: > > [EMAIL PROTECTED] (Bruce Momjian) writes: > > > Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ 0.0 > > > return 1, rather than error. > > > > This is wrongly described, and the implementation is still