Re: [COMMITTERS] pgsql: plpython improvements: 1) named parameters additionally

2006-04-26 Thread Kris Jurka
Bruce Momjian wrote: Log Message: --- plpython improvements: These don't seem to work: http://pgbuildfarm.org/cgi-bin/show_status.pl ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.pos

[COMMITTERS] pgsql: Add SSL include needed for psql, after libpq adjustments.

2006-04-26 Thread Bruce Momjian
Log Message: --- Add SSL include needed for psql, after libpq adjustments. Modified Files: -- pgsql/src/bin/psql: startup.c (r1.131 -> r1.132) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/startup.c.diff?r1=1.131&r2=1.132)

Re: [COMMITTERS] pgsql: Change libpq's PQgetssl() to return a void*,

2006-04-26 Thread Bruce Momjian
Kris Jurka wrote: > Bruce Momjian wrote: > > Log Message: > > --- > > Change libpq's PQgetssl() to return a void*, rather than SSL *, so that > > applications don't need the SSL headers. > > > > Now that libpq-fe.h doesn't include the code in psql's > startup.c needs to include it itsel

Re: [COMMITTERS] pgsql: Change libpq's PQgetssl() to return a void*, rather than

2006-04-26 Thread Kris Jurka
Bruce Momjian wrote: Log Message: --- Change libpq's PQgetssl() to return a void*, rather than SSL *, so that applications don't need the SSL headers. Now that libpq-fe.h doesn't include the code in psql's startup.c needs to include it itself. ---(end of bro

[COMMITTERS] pgsql: Add: > * Invalidate prepared queries, like INSERT, when the

2006-04-26 Thread Bruce Momjian
Log Message: --- Add: > * Invalidate prepared queries, like INSERT, when the table definition > is altered Modified Files: -- pgsql/doc: TODO (r1.1814 -> r1.1815) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1814&r2=1.1815) pg

[COMMITTERS] pgsql: Add support for SSL Certificate Revocation List (CRL) files,

2006-04-26 Thread Bruce Momjian
Log Message: --- Add support for SSL Certificate Revocation List (CRL) files, root.crl. Libor Hoho? Modified Files: -- pgsql/doc/src/sgml: runtime.sgml (r1.370 -> r1.371) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/runtime.sgml.diff?r1=1

[COMMITTERS] pgsql: plpython improvements: 1) named parameters additionally to

2006-04-26 Thread Bruce Momjian
Log Message: --- plpython improvements: 1) named parameters additionally to args[] 2) return composite-types from plpython as dictionary 3) return result-set from plpython as list, iterator or generator Hannu Krosing Sven Suursoho Modified Files: --

[COMMITTERS] pgsql: Un-break ltree.

2006-04-26 Thread Tom Lane
Log Message: --- Un-break ltree. Modified Files: -- pgsql/contrib/ltree: ltree.sql.in (r1.12 -> r1.13) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/ltree.sql.in.diff?r1=1.12&r2=1.13) ---(end of broadcast)-

[COMMITTERS] pgsql: Change libpq's PQgetssl() to return a void*, rather than SSL *,

2006-04-26 Thread Bruce Momjian
Log Message: --- Change libpq's PQgetssl() to return a void*, rather than SSL *, so that applications don't need the SSL headers. Martijn van Oosterhout Modified Files: -- pgsql/src/interfaces/libpq: fe-secure.c (r1.76 -> r1.77) (http://developer.postgresq

[COMMITTERS] pgsql: If we're going to expose VariableStatData for contrib modules to

2006-04-26 Thread Tom Lane
Log Message: --- If we're going to expose VariableStatData for contrib modules to use, then we should export a reasonable set of the supporting routines too. Modified Files: -- pgsql/src/backend/utils/adt: selfuncs.c (r1.201 -> r1.202) (http://developer.pos

[COMMITTERS] pgsql: Remove unused function SSL_CTX_set_tmp_dh_callback() from libpq:

2006-04-26 Thread Bruce Momjian
Log Message: --- Remove unused function SSL_CTX_set_tmp_dh_callback() from libpq: In the SSL code in libpq it does some processing with DH parameters: SSL_CTX_set_tmp_dh_callback() This function is marked as server use only[1], the client always uses the DH parameters in the server, so a

[COMMITTERS] pgsql: Use schema search path to find the first matching contraint name

2006-04-26 Thread Bruce Momjian
Log Message: --- Use schema search path to find the first matching contraint name for SET CONSTRAINT, rather than affecting all constraints in all schemas (which is what we used to do). Also allow schema specifications. Kris Jurka Modified Files: -- pgsql/doc/src/sgml/ref

[COMMITTERS] pgsql: Delay write of pg_stats file to once every five minutes, during

2006-04-26 Thread Bruce Momjian
Log Message: --- Delay write of pg_stats file to once every five minutes, during shutdown, or when requested by a backend: It changes so the file is only written once every 5 minutes (changeable of course, I just picked something) instead of once every half second. It's still written when

[COMMITTERS] pgsql: Add tablespace display to psql \l+.

2006-04-26 Thread Bruce Momjian
Log Message: --- Add tablespace display to psql \l+. Philip Yarra Modified Files: -- pgsql/src/bin/psql: describe.c (r1.133 -> r1.134) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.c.diff?r1=1.133&r2=1.134) --

[COMMITTERS] pgsql: Fix SELECT INTO and CREATE TABLE AS to create tables in the

2006-04-26 Thread Bruce Momjian
Log Message: --- Fix SELECT INTO and CREATE TABLE AS to create tables in the default tablespace, not the base directory. Kris Jurka Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/executor: execMain.c (r1.256.2.5 -> r1.256.2.6) (http://devel

[COMMITTERS] pgsql: Fix SELECT INTO and CREATE TABLE AS to create tables in the

2006-04-26 Thread Bruce Momjian
Log Message: --- Fix SELECT INTO and CREATE TABLE AS to create tables in the default tablespace, not the base directory. Kris Jurka Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/executor: execMain.c (r1.241.4.2 -> r1.241.4.3) (http://devel

[COMMITTERS] pgsql: Improve /contrib/pg_buffercache installation to use BEGIN/COMMIT,

2006-04-26 Thread Bruce Momjian
Log Message: --- Improve /contrib/pg_buffercache installation to use BEGIN/COMMIT, improve examples. Mark Kirkwood Modified Files: -- pgsql/contrib/pg_buffercache: README.pg_buffercache (r1.2 -> r1.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contr

[COMMITTERS] pgsql: Split out pg_freespace views to one for relations and another for

2006-04-26 Thread Bruce Momjian
Log Message: --- Split out pg_freespace views to one for relations and another for pages, pg_freespacemap_relations and pg_freespacemap_pages. Mark Kirkwood Modified Files: -- pgsql/contrib/pg_freespacemap: README.pg_freespacemap (r1.2 -> r1.3) (http://dev

[COMMITTERS] pgsql: Adjust /contrib/pg_freespace to show index free space as NULL

2006-04-26 Thread Bruce Momjian
Log Message: --- Adjust /contrib/pg_freespace to show index free space as NULL (FSM only tracks index pages, not free space on pages): 1/ Index free bytes set to NULL 2/ Comment added to the README briefly mentioning the index business 3/ Columns reordered more logically 4/ 'Blockid' colum

[COMMITTERS] pgsql: Move ltree parentsel() selectivity function into /contrib/ltree.

2006-04-26 Thread Bruce Momjian
Log Message: --- Move ltree parentsel() selectivity function into /contrib/ltree. Modified Files: -- pgsql/contrib/ltree: ltree.sql.in (r1.11 -> r1.12) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/ltree.sql.in.diff?r1=1.11&r2=1.12)

[COMMITTERS] pgsql: In pg_resetxlog.c, uint -> uint32, for Win32 port.

2006-04-26 Thread Bruce Momjian
Log Message: --- In pg_resetxlog.c, uint -> uint32, for Win32 port. Modified Files: -- pgsql/src/bin/pg_resetxlog: pg_resetxlog.c (r1.45 -> r1.46) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_resetxlog/pg_resetxlog.c.diff?r1=1.45&r2=1.46) -

[COMMITTERS] pgsql: Add missing ControlFile.checkPointCopy.ThisTimeLineID line for

2006-04-26 Thread Bruce Momjian
Log Message: --- Add missing ControlFile.checkPointCopy.ThisTimeLineID line for 'guess' pg_resetxlog. Simon Modified Files: -- pgsql/src/bin/pg_resetxlog: pg_resetxlog.c (r1.44 -> r1.45) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_resetxlo

Re: [COMMITTERS] pgsql: Allow pg_resetxlog -f to reset pg_control

2006-04-26 Thread Bruce Momjian
Simon Riggs wrote: > > It appears to me that a line like this has been missed out for when > mode==GUESS > > ControlFile.checkPointCopy.ThisTimeLineID = 2; > > (search for 514...) > > The old line which guessed at > ControlFile.checkPointCopy.ThisTimeLineID = 1; > has been removed,

[COMMITTERS] pgsql: Update catalog version for ltree changes.

2006-04-26 Thread Bruce Momjian
Log Message: --- Update catalog version for ltree changes. Modified Files: -- pgsql/src/include/catalog: catversion.h (r1.324 -> r1.325) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.324&r2=1.325)

[COMMITTERS] pgsql: Enhanced containment selectivity function for /contrib/ltree

2006-04-26 Thread Bruce Momjian
Log Message: --- Enhanced containment selectivity function for /contrib/ltree Matteo Beccati Modified Files: -- pgsql/contrib/ltree: ltree.sql.in (r1.10 -> r1.11) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/ltree.sql.in.diff?r1=1.10&r2=

Re: [COMMITTERS] pgsql: Allow pg_resetxlog -f to reset pg_control

2006-04-26 Thread Simon Riggs
It appears to me that a line like this has been missed out for when mode==GUESS ControlFile.checkPointCopy.ThisTimeLineID = 2; (search for 514...) The old line which guessed at ControlFile.checkPointCopy.ThisTimeLineID = 1; has been removed, but with nothing to replace it, exce