[COMMITTERS] pgsql: Make the new pg_stat_get_activity use OUT parameters, so you

2008-05-08 Thread Magnus Hagander
Log Message: --- Make the new pg_stat_get_activity use OUT parameters, so you don't have to specify the column names and types. Also simplifies the view. Per comments from Tom. Modified Files: -- pgsql/src/backend/catalog: system_views.sql (r1.50 -> r1.51)

Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF

2008-05-08 Thread Magnus Hagander
Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Why not declare it with OUT parameters, instead? > > > That does sound like a very good idea... I did notice that as being > > a problem, but didn't know how to fix it without thinking more :-) > > How do I do t

[COMMITTERS] libpqtypes - libpqtypes: removed libpqtypes.h comments since they are

2008-05-08 Thread User Achernow
Log Message: --- removed libpqtypes.h comments since they are now in man pages Modified Files: -- libpqtypes/src: libpqtypes.h (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/src/libpqtypes.h.diff?r1=1.1&r2=1.2) -- Sent v

Re: [COMMITTERS] pgsql: Make the new pg_stat_get_activity use OUT parameters, so you

2008-05-08 Thread Tom Lane
[EMAIL PROTECTED] (Magnus Hagander) writes: > Make the new pg_stat_get_activity use OUT parameters, so you don't have to > specify the column names and types. Also simplifies the view. The buildfarm says you forgot to update rules.out :-( regards, tom lane -- Sent via pg

[COMMITTERS] libpqtypes - libpqtypes: updated groff2html (added #include support),

2008-05-08 Thread User Achernow
Log Message: --- updated groff2html (added #include support), fixed tabs in libpqtypes.h Modified Files: -- libpqtypes: groff2html (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/groff2html.diff?r1=1.6&r2=1.7) libpqtype

[COMMITTERS] pgsql: Fix rules regression test for recent pg_stat_activity change.

2008-05-08 Thread Tom Lane
Log Message: --- Fix rules regression test for recent pg_stat_activity change. Modified Files: -- pgsql/src/test/regress/expected: rules.out (r1.137 -> r1.138) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out?r1=1.137&r2=1

Re: [COMMITTERS] pgsql: Make the new pg_stat_get_activity use OUT parameters, so you

2008-05-08 Thread Magnus Hagander
Tom Lane wrote: > [EMAIL PROTECTED] (Magnus Hagander) writes: > > Make the new pg_stat_get_activity use OUT parameters, so you don't > > have to specify the column names and types. Also simplifies the > > view. > > The buildfarm says you forgot to update rules.out :-( Argh, stupid. I modified the

[COMMITTERS] pgsql: Fix contrib/xml2 makefile to not override CFLAGS, and in passing

2008-05-08 Thread Tom Lane
Log Message: --- Fix contrib/xml2 makefile to not override CFLAGS, and in passing make it auto-configure properly for libxslt present or not. Modified Files: -- pgsql/contrib: Makefile (r1.82 -> r1.83) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib

[COMMITTERS] pgsql: Fix contrib/xml2 makefile to not override CFLAGS, and in passing

2008-05-08 Thread Tom Lane
Log Message: --- Fix contrib/xml2 makefile to not override CFLAGS, and in passing make it auto-configure properly for libxslt present or not. Tags: REL8_3_STABLE Modified Files: -- pgsql/contrib: Makefile (r1.82 -> r1.82.2.1) (http://anoncvs.postgresq

[COMMITTERS] pgsql: Add psql '\pset format wrapped' mode to wrap output to screen

2008-05-08 Thread Bruce Momjian
Log Message: --- Add psql '\pset format wrapped' mode to wrap output to screen width, or file/pipe output too if \pset columns' is set. Bryce Nesbitt Modified Files: -- pgsql/doc/src/sgml/ref: psql-ref.sgml (r1.202 -> r1.203) (http://anoncvs.postgresql.org

[COMMITTERS] pgsql: Fix contrib/xml2 makefile to not override CFLAGS.

2008-05-08 Thread Tom Lane
Log Message: --- Fix contrib/xml2 makefile to not override CFLAGS. Tags: REL8_2_STABLE Modified Files: -- pgsql/contrib/xml2: Makefile (r1.8 -> r1.8.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/Makefile?r1=1.8&r2=1.8.2.1) -- Sen

[COMMITTERS] pgsql: Fix contrib/xml2 makefile to not override CFLAGS.

2008-05-08 Thread Tom Lane
Log Message: --- Fix contrib/xml2 makefile to not override CFLAGS. Tags: REL8_1_STABLE Modified Files: -- pgsql/contrib/xml2: Makefile (r1.6.2.1 -> r1.6.2.2) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/Makefile?r1=1.6.2.1&r2=1.6.2.2)

[COMMITTERS] pgsql: Fix contrib/xml2 makefile to not override CFLAGS.

2008-05-08 Thread Tom Lane
Log Message: --- Fix contrib/xml2 makefile to not override CFLAGS. Tags: REL8_0_STABLE Modified Files: -- pgsql/contrib/xml2: Makefile (r1.5.4.1 -> r1.5.4.2) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/Makefile?r1=1.5.4.1&r2=1.5.4.2)

[COMMITTERS] pgsql: Fix contrib/xml makefile to not override CFLAGS.

2008-05-08 Thread Tom Lane
Log Message: --- Fix contrib/xml makefile to not override CFLAGS. Tags: REL8_0_STABLE Modified Files: -- pgsql/contrib/xml: Makefile (r1.10 -> r1.10.4.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/xml/Makefile?r1=1.10&r2=1.10.4.1) -- Se

[COMMITTERS] libpqtypes - libpqtypes: tab fix in libpqtypes.h

2008-05-08 Thread User Achernow
Log Message: --- tab fix in libpqtypes.h Modified Files: -- libpqtypes/src: libpqtypes.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/src/libpqtypes.h.diff?r1=1.3&r2=1.4) -- Sent via pgsql-committers mailing list (pgsq

[COMMITTERS] libpqtypes - libpqtypes: updated man page for paramcreate

2008-05-08 Thread User Achernow
Log Message: --- updated man page for paramcreate Modified Files: -- libpqtypes/docs/man3: PQparamCreate.3 (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/docs/man3/PQparamCreate.3.diff?r1=1.2&r2=1.3) -- Sent via pgsql-co

[COMMITTERS] libpqtypes - libpqtypes: updated man page for putf

2008-05-08 Thread User Achernow
Log Message: --- updated man page for putf Modified Files: -- libpqtypes/docs/man3: PQputf.3 (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/docs/man3/PQputf.3.diff?r1=1.3&r2=1.4) -- Sent via pgsql-committers mailing list

[COMMITTERS] libpqtypes - libpqtypes: updated man page for PQtypesObjectHooks

2008-05-08 Thread User Achernow
Log Message: --- updated man page for PQtypesObjectHooks Modified Files: -- libpqtypes/docs/man3: PQtypesObjectHooks.3 (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/docs/man3/PQtypesObjectHooks.3.diff?r1=1.3&r2=1.4) --

[COMMITTERS] pgsql: Have psql output tab as the proper number of spaces, rather than

2008-05-08 Thread Bruce Momjian
Log Message: --- Have psql output tab as the proper number of spaces, rather than \x09. Modified Files: -- pgsql/src/bin/psql: mbprint.c (r1.31 -> r1.32) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/mbprint.c?r1=1.31&r2=1.32) pgsql/src/t

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

2008-05-08 Thread Bruce Momjian
Log Message: --- Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ 0.0 return 1, rather than error. This was already the float8 behavior. Modified Files: -- pgsql/src/backend/utils/adt: numeric.c (r1.110 -> r1.111) (http://anoncvs.postgresq

[COMMITTERS] pginstaller - web: Move the running on native windows FAQ to the wiki.

2008-05-08 Thread User Mha
Log Message: --- Move the running on native windows FAQ to the wiki. Modified Files: -- web/faq: FAQ_windows.html (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/web/faq/FAQ_windows.html.diff?r1=1.16&r2=1.17) -- Sent via pgsql-co

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

2008-05-08 Thread Neil Conway
On Thu, 2008-05-08 at 19:25 +, Bruce Momjian wrote: > Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ 0.0 > return 1, rather than error. A regression test for this behavior would be useful, I think. -Neil -- Sent via pgsql-committers mailing list (pgsql-committers@postgr

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

2008-05-08 Thread Bruce Momjian
Log Message: --- Add regression test for various power expressions with a zero base, and adjust source code to be more modular. Modified Files: -- pgsql/src/backend/utils/adt: numeric.c (r1.111 -> r1.112) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/

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

2008-05-08 Thread Bruce Momjian
Neil Conway wrote: > On Thu, 2008-05-08 at 19:25 +, Bruce Momjian wrote: > > Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ 0.0 > > return 1, rather than error. > > A regression test for this behavior would be useful, I think. Done, plus I wasn't happy with the original pat

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

2008-05-08 Thread Tom Lane
[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 not correct either, because it should throw an error for negative exponents. Would you please

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

2008-05-08 Thread Bruce Momjian
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 not correct > either, because it should throw an error for negative

[COMMITTERS] libpqtypes - libpqtypes: added copyright notices to all source files

2008-05-08 Thread User Achernow
Log Message: --- added copyright notices to all source files Modified Files: -- libpqtypes: groff2html (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/libpqtypes/libpqtypes/groff2html.diff?r1=1.7&r2=1.8) libpqtypes/src: array.c (r1.1

[COMMITTERS] pgsql: Add to TODO: > > * Improve the /contrib installation experience

2008-05-08 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Improve the /contrib installation experience > > http://archives.postgresql.org/pgsql-hackers/2008-04/msg00132.php Modified Files: -- pgsql/doc: TODO (r1.2450 -> r1.2451) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsq

[COMMITTERS] pgsql: Fix memory stomp that's turning the whole buildfarm pink: you

2008-05-08 Thread Tom Lane
Log Message: --- Fix memory stomp that's turning the whole buildfarm pink: you can't hack up pg_wcsformat without changing pg_wcssize to match. Add some comments to try to make that clearer, and make a couple other minor editorializations. Modified Files: -- pgsql/src/bin/

[COMMITTERS] pgsql: Fix bogus expected output that should have made it quite clear

2008-05-08 Thread Tom Lane
Log Message: --- Fix bogus expected output that should have made it quite clear that something was wrong with that tab patch. Modified Files: -- pgsql/src/test/regress/expected: prepare.out (r1.16 -> r1.17) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/sr