[COMMITTERS] pgsql: Add NO_PGPORT defines to fix win32/cygwin builds for new target
Log Message: --- Add NO_PGPORT defines to fix win32/cygwin builds for new target platform build of zic. Modified Files: -- pgsql/src/include: port.h (r1.77 -> r1.78) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/port.h.diff?r1=1.77&r2=1.78) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgsql: Fix initialization bug in pgcrypto openssl code.
Log Message: --- Fix initialization bug in pgcrypto openssl code. Marko Kreen Modified Files: -- pgsql/contrib/pgcrypto: openssl.c (r1.19 -> r1.20) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/openssl.c.diff?r1=1.19&r2=1.20) pgsql/contrib/pgcrypto/expected: 3des.out (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/expected/3des.out.diff?r1=1.1&r2=1.2) pgsql/contrib/pgcrypto/sql: 3des.sql (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/sql/3des.sql.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql: Back out patch.
Log Message: --- Back out patch. This should be done like other server-side languages. --- This patch allows the PL/Python module to do (SRF) functions. The patch was taken from the CVS version. I have modified the plpython.c file and have added a test sql script for testing the functionality. It was actually the script that was in the 8.0.3 version but have since been removed. In order to signal the end of a set, the called python function must simply return plpy.EndOfSet and the set would be returned. Gerrit van Dyk Modified Files: -- pgsql/src/pl/plpython: plpython.c (r1.63 -> r1.64) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpython/plpython.c.diff?r1=1.63&r2=1.64) Removed Files: - pgsql/src/pl/plpython/sql: plpython_setof.sql (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpython/sql/plpython_setof.sql) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] dblink-tds - dblink_tds:
Log Message: --- Tags: stable74 Modified Files: -- dblink_tds: README.dblink_tds (r1.2 -> r1.2.2.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dblink-tds/dblink_tds/README.dblink_tds.diff?r1=1.2&r2=1.2.2.1) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] dblink-tds - dblink_tds: adi��o da documenta��o dos novos recursos
Log Message: --- adição da documentação dos novos recursos Tags: stable80 Modified Files: -- dblink_tds: README.dblink_tds (r1.1 -> r1.1.2.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dblink-tds/dblink_tds/README.dblink_tds.diff?r1=1.1&r2=1.1.2.1) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] dblink-tds - dblink_tds:
Log Message: --- Tags: stable80 Modified Files: -- dblink_tds: README.dblink_tds (r1.1.2.1 -> r1.1.2.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/dblink-tds/dblink_tds/README.dblink_tds.diff?r1=1.1.2.1&r2=1.1.2.2) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql: Add: < 881a881,882 > o Improve xid wraparound detection by
Log Message: --- Add: < 881a881,882 > o Improve xid wraparound detection by recording per-table rather > than per-database Modified Files: -- pgsql/doc: TODO (r1.1591 -> r1.1592) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1591&r2=1.1592) pgsql/doc/src/FAQ: TODO.html (r1.98 -> r1.99) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.98&r2=1.99) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql: Remove, now have GUC: < * Turn off full page writes if fsync is
Log Message: --- Remove, now have GUC: < * Turn off full page writes if fsync is disabled < < If fsync is off, there is no purpose in writing full pages to WAL < Modified Files: -- pgsql/doc: TODO (r1.1592 -> r1.1593) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1592&r2=1.1593) pgsql/doc/src/FAQ: TODO.html (r1.99 -> r1.100) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.99&r2=1.100) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql: Dept of second thoughts: don't expose rijndael.tbl: rijndael.c
Log Message: --- Dept of second thoughts: don't expose rijndael.tbl: rijndael.c dependency to make. We ship the table file in the tarball and so this dependency just opens file timestamp skew problems without doing anything useful. (Not that it should hurt, either ... except for cross-compile builds.) Modified Files: -- pgsql/contrib/pgcrypto: Makefile (r1.15 -> r1.16) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/Makefile.diff?r1=1.15&r2=1.16) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql: Fix contrib/pgcrypto to autoconfigure for OpenSSL when
Log Message: --- Fix contrib/pgcrypto to autoconfigure for OpenSSL when --with-openssl is used in the toplevel configure. Per Marko Kreen. Modified Files: -- pgsql: configure (r1.442 -> r1.443) (http://developer.postgresql.org/cvsweb.cgi/pgsql/configure.diff?r1=1.442&r2=1.443) configure.in (r1.415 -> r1.416) (http://developer.postgresql.org/cvsweb.cgi/pgsql/configure.in.diff?r1=1.415&r2=1.416) pgsql/contrib/pgcrypto: Makefile (r1.14 -> r1.15) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/Makefile.diff?r1=1.14&r2=1.15) pgsql/src: Makefile.global.in (r1.215 -> r1.216) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/Makefile.global.in.diff?r1=1.215&r2=1.216) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] pgsql: Add GUC full_page_writes to control writing full pages to WAL.
Log Message: --- Add GUC full_page_writes to control writing full pages to WAL. Modified Files: -- pgsql/doc/src/sgml: runtime.sgml (r1.335 -> r1.336) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/runtime.sgml.diff?r1=1.335&r2=1.336) pgsql/src/backend/access/transam: xlog.c (r1.206 -> r1.207) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c.diff?r1=1.206&r2=1.207) pgsql/src/backend/utils/misc: guc.c (r1.272 -> r1.273) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c.diff?r1=1.272&r2=1.273) postgresql.conf.sample (r1.151 -> r1.152) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample.diff?r1=1.151&r2=1.152) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgsql: Attached is a patch that enhances the "\h" capability in psql.
Log Message: --- Attached is a patch that enhances the "\h" capability in psql. I often find myself typing a command and then wanting to get the syntax for it. So I do a ctrl-a and add a \h: but psql does not recognize the command, because I have stuff attached to it (e.g. "alter table foobar"), so I have to scroll over and delete everything except the name of the command itself. This patch gives \h three chances to match: if nothing matches the complete string (current behavior), it tries to match the first two words (e.g. "ALTER TABLE"). If that fails, it tries to match the first word (e.g. "DELETE"). Greg Sabino Mullane Modified Files: -- pgsql/src/bin/psql: help.c (r1.102 -> r1.103) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/help.c.diff?r1=1.102&r2=1.103) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [COMMITTERS] pgsql: Fix contrib/pgcrypto to autoconfigure for
On Tue, 5 Jul 2005, Tom Lane wrote: > Log Message: > --- > Fix contrib/pgcrypto to autoconfigure for OpenSSL when --with-openssl > is used in the toplevel configure. Per Marko Kreen. > This seems to have broken the canary buildfarm member: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=canary&dt=2005-07-06%2002:30:01 ldd on pgcrypto.so shows: -lc.12 => /usr/lib/libc.so.12 -lcrypto.300 => /usr/pkg/lib/libcrypto.so.300 -lssl.300 => /usr/pkg/lib/libssl.so.300 -lcrypt.0 => /usr/lib/libcrypt.so.0 if that's any help. Kris Jurka ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgsql: Done: > * -Add function to return compressed length of TOAST
Log Message: --- Done: > * -Add function to return compressed length of TOAST data values Modified Files: -- pgsql/doc: TODO (r1.1593 -> r1.1594) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1593&r2=1.1594) pgsql/doc/src/FAQ: TODO.html (r1.100 -> r1.101) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.100&r2=1.101) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [COMMITTERS] pgsql: Fix contrib/pgcrypto to autoconfigure for OpenSSL when
Kris Jurka <[EMAIL PROTECTED]> writes: > This seems to have broken the canary buildfarm member: > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=canary&dt=2005-07-06%2002:30:01 Not a lot of help there: ERROR: could not load library "/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so": dlopen (/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so) failed ERROR: could not load library "/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so": dlopen (/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so) failed ERROR: could not load library "/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so": dlopen (/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so) failed On most Unixen that I've dealt with, this sort of shared-library load failure is accompanied by some actually-useful detail messages on stderr. It looks like the buildfarm infrastructure is losing that detail :-( regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [COMMITTERS] pgsql: Fix contrib/pgcrypto to autoconfigure for
On Wed, 6 Jul 2005, Tom Lane wrote: > Not a lot of help there: > > ERROR: could not load library > "/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so": dlopen > (/usr/home/pgfarm/netbsd/HEAD/inst/lib/postgresql/pgcrypto.so) failed > > On most Unixen that I've dealt with, this sort of shared-library load > failure is accompanied by some actually-useful detail messages on > stderr. It looks like the buildfarm infrastructure is losing that > detail :-( > Actually it looks like the netbsd dynloader code is at fault. The attached patch gives me: ERROR: could not load library "/usr/home/jurka/tmp/pg81/lib/postgresql/pgcrypto.so": dlopen '/usr/home/jurka/tmp/pg81/lib/postgresql/pgcrypto.so' failed. (/usr/home/jurka/tmp/pg81/lib/postgresql/pgcrypto.so: Undefined PLT symbol "DES_set_key" (reloc type = 7, symnum = 75)) Note also that openbsd's dynloader is missing this error reporting. Kris JurkaIndex: src/backend/port/dynloader/netbsd.c === RCS file: /projects/cvsroot/pgsql/src/backend/port/dynloader/netbsd.c,v retrieving revision 1.16 diff -c -r1.16 netbsd.c *** src/backend/port/dynloader/netbsd.c 31 Dec 2004 22:00:32 - 1.16 --- src/backend/port/dynloader/netbsd.c 6 Jul 2005 06:36:20 - *** *** 68,74 if ((vp = dlopen((char *) file, num)) == NULL) snprintf(error_message, sizeof(error_message), !"dlopen (%s) failed", file); return vp; #endif } --- 68,74 if ((vp = dlopen((char *) file, num)) == NULL) snprintf(error_message, sizeof(error_message), !"dlopen '%s' failed. (%s) ", file, dlerror()); return vp; #endif } ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
