Re: [COMMITTERS] pgsql: Create a GUC parameter temp_tablespacesthat allows selection of

2007-06-04 Thread Bruce Momjian
Tom Lane wrote: > "Simon Riggs" <[EMAIL PROTECTED]> writes: > > One of the main reasons for the implementation was to allow larger > > queries to work faster by utilising multiple temp tablespaces for the > > same query. > > > The original ideal implementation was to use round-robin/cyclic > > sel

[COMMITTERS] pgsql: Remove ill-conceived CRLF translation for Windows in syslogger.

2007-06-04 Thread Andrew Dunstan
Log Message: --- Remove ill-conceived CRLF translation for Windows in syslogger. Modified Files: -- pgsql/src/backend/postmaster: syslogger.c (r1.30 -> r1.31) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/syslogger.c.diff?r1=1.30&

[COMMITTERS] pgsql: Tidy overly long configure help lines.

2007-06-04 Thread Andrew Dunstan
Log Message: --- Tidy overly long configure help lines. Modified Files: -- pgsql: configure.in (r1.514 -> r1.515) (http://developer.postgresql.org/cvsweb.cgi/pgsql/configure.in.diff?r1=1.514&r2=1.515) configure (r1.547 -> r1.548) (http://de

Re: [COMMITTERS] pgsql: Create a GUC parametertemp_tablespacesthat allows selection of

2007-06-04 Thread Simon Riggs
On Mon, 2007-06-04 at 14:41 -0400, Tom Lane wrote: > "Simon Riggs" <[EMAIL PROTECTED]> writes: > > One of the main reasons for the implementation was to allow larger > > queries to work faster by utilising multiple temp tablespaces for the > > same query. > > > The original ideal implementation wa

Re: [COMMITTERS] pgsql: Create a GUC parameter temp_tablespacesthat allows selection of

2007-06-04 Thread Tom Lane
"Simon Riggs" <[EMAIL PROTECTED]> writes: > One of the main reasons for the implementation was to allow larger > queries to work faster by utilising multiple temp tablespaces for the > same query. > The original ideal implementation was to use round-robin/cyclic > selection, which allows much bett

Re: [COMMITTERS] pgsql: Create a GUC parameter temp_tablespacesthat allows selection of

2007-06-04 Thread Simon Riggs
On Sun, 2007-06-03 at 14:08 -0300, Tom Lane wrote: > a random list element is chosen each time a temp object is to be > created I don't seem to be able to find discussion on this point on -hackers. One of the main reasons for the implementation was to allow larger queries to work faster by utili

[COMMITTERS] pgsql: Fix bundle bugs of GIN: - Fix possible deadlock between UPDATE

2007-06-04 Thread Teodor Sigaev
Log Message: --- Fix bundle bugs of GIN: - Fix possible deadlock between UPDATE and VACUUM queries. Bug never was observed in 8.2, but it still exist there. HEAD is more sensitive to bug after recent "ring" of buffer improvements. - Fix WAL creation: if parent page is stored as is after

[COMMITTERS] pgsql: Fix bundle bugs of GIN: - Fix possible deadlock between UPDATE

2007-06-04 Thread Teodor Sigaev
Log Message: --- Fix bundle bugs of GIN: - Fix possible deadlock between UPDATE and VACUUM queries. Bug never was observed in 8.2, but it still exist there. HEAD is more sensitive to bug after recent "ring" of buffer improvements. - Fix WAL creation: if parent page is stored as is after

Re: [COMMITTERS] pgsql: Clarify some error messages about duplicate things.

2007-06-04 Thread Peter Eisentraut
Am Montag, 4. Juni 2007 15:14 schrieb Gregory Stark: > Could we hold off on these kinds of cosmetic fixups that touch dozens of > files until we're done processing the largish patches in the queue? I think we could. -- Peter Eisentraut http://developer.postgresql.org/~petere/ --

[COMMITTERS] pgsql: Oops.

2007-06-04 Thread Magnus Hagander
Log Message: --- Oops. Patch didn't work properly for 8.1, so don't backpatch a then-unused variable either. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/port/win32: socket.c (r1.10.2.3 -> r1.10.2.4) (http://developer.postgresql.org/cvsweb

[COMMITTERS] pgsql: On win32, retry reading when WSARecv returns WSAEWOULDBLOCK.

2007-06-04 Thread Magnus Hagander
Log Message: --- On win32, retry reading when WSARecv returns WSAEWOULDBLOCK. There seem to be cases when at least Windows 2000 can do this even though select just indicated that the socket is readable. Per report and analysis from Cyril VELTER. Tags: REL8_2_STABLE Modified Files: -

[COMMITTERS] pgsql: On win32, retry reading when WSARecv returns WSAEWOULDBLOCK.

2007-06-04 Thread Magnus Hagander
Log Message: --- On win32, retry reading when WSARecv returns WSAEWOULDBLOCK. There seem to be cases when at least Windows 2000 can do this even though select just indicated that the socket is readable. Per report and analysis from Cyril VELTER. Modified Files: -- pgsql/sr

[COMMITTERS] pgsql: On win32, retry reading when WSARecv returns WSAEWOULDBLOCK.

2007-06-04 Thread Magnus Hagander
Log Message: --- On win32, retry reading when WSARecv returns WSAEWOULDBLOCK. There seem to be cases when at least Windows 2000 can do this even though select just indicated that the socket is readable. Per report and analysis from Cyril VELTER. Tags: REL8_1_STABLE Modified Files: -

[COMMITTERS] pginstaller - pginst: Update the Russian translation, and add a Ukranian

2007-06-04 Thread User Dpage
Log Message: --- Update the Russian translation, and add a Ukranian one, both courtesy of Andrey Repko. Modified Files: -- pginst/lang: languages.projinc (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/lang/languages.projinc.

Re: [COMMITTERS] pgsql: Clarify some error messages about duplicate things.

2007-06-04 Thread Gregory Stark
"Peter Eisentraut" <[EMAIL PROTECTED]> writes: > Log Message: > --- > Clarify some error messages about duplicate things. Could we hold off on these kinds of cosmetic fixups that touch dozens of files until we're done processing the largish patches in the queue? They cause lots of bitrot

[COMMITTERS] pgloader - pgloader: CSV support, can load not-all-columns of data

2007-06-04 Thread User Dim
Log Message: --- CSV support, can load not-all-columns of data files, can load to table with more cols than data file Modified Files: -- pgloader: pgloader.1.sgml (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgloader/pgloader/pgloader.1.sgml

[COMMITTERS] pgloader - pgloader: New Directory

2007-06-04 Thread User Dim
Update of /cvsroot/pgloader/pgloader/examples/partial In directory pgfoundry.org:/tmp/cvs-serv50623/partial Log Message: Directory /cvsroot/pgloader/pgloader/examples/partial added to the repository ---(end of broadcast)--- TIP 5: don't forget to i

[COMMITTERS] pgloader - pgloader: New Directory

2007-06-04 Thread User Dim
Update of /cvsroot/pgloader/pgloader/examples/csv In directory pgfoundry.org:/tmp/cvs-serv50623/csv Log Message: Directory /cvsroot/pgloader/pgloader/examples/csv added to the repository ---(end of broadcast)--- TIP 9: In versions below 8.0, the pl

[COMMITTERS] pgsql: On win32, don't use SO_REUSEADDR for TCP sockets.

2007-06-04 Thread Magnus Hagander
Log Message: --- On win32, don't use SO_REUSEADDR for TCP sockets. Per failure on buildfarm member baiji and subsequent discussion. Tags: REL8_2_STABLE Modified Files: -- pgsql/src/backend/libpq: pqcomm.c (r1.188 -> r1.188.2.1) (http://developer.post

[COMMITTERS] pgsql: On win32, don't use SO_REUSEADDR for TCP sockets.

2007-06-04 Thread Magnus Hagander
Log Message: --- On win32, don't use SO_REUSEADDR for TCP sockets. Per failure on buildfarm member baiji and subsequent discussion. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/libpq: pqcomm.c (r1.182.2.1 -> r1.182.2.2) (http://developer.

[COMMITTERS] pgsql: On win32, don't use SO_REUSEADDR for TCP sockets.

2007-06-04 Thread Magnus Hagander
Log Message: --- On win32, don't use SO_REUSEADDR for TCP sockets. Per failure on buildfarm member baiji and subsequent discussion. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/libpq: pqcomm.c (r1.175 -> r1.175.4.1) (http://developer.post

[COMMITTERS] pgsql: On win32, don't use SO_REUSEADDR for TCP sockets.

2007-06-04 Thread Magnus Hagander
Log Message: --- On win32, don't use SO_REUSEADDR for TCP sockets. Per failure on buildfarm member baiji and subsequent discussion. Modified Files: -- pgsql/src/backend/libpq: pqcomm.c (r1.191 -> r1.192) (http://developer.postgresql.org/cvsweb.cgi/pgsql/sr

[COMMITTERS] psqlodbc - psqlodbc: Handle standard_conforming_strings also in case via

2007-06-04 Thread User Hinoue
Log Message: --- Handle standard_conforming_strings also in case via libpq. Modified Files: -- psqlodbc: connection.c (r1.160 -> r1.161) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/connection.c.diff?r1=1.160&r2=1.161) version.h (r

[COMMITTERS] psqlodbc - psqlodbc: . Add CC_set_autocommit to psqlodbc(a).def files. .

2007-06-04 Thread User Hinoue
Log Message: --- . Add CC_set_autocommit to psqlodbc(a).def files. . Handle Standard_conforming_strings. Modified Files: -- psqlodbc: connection.c (r1.159 -> r1.160) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/connection.c.diff?r1=1.159&r

[COMMITTERS] pgsql: Remove gratuitous response messages from utility programs.

2007-06-04 Thread Peter Eisentraut
Log Message: --- Remove gratuitous response messages from utility programs. (Possibly release notes material, lest users be confused.) The --quiet option is now obsolete and without effect in createdb, createuser, dropdb, dropuser; kept for compatibility but marked for removal in 8.4. Pr

[COMMITTERS] pgsql: Update expected files for textual changes

2007-06-04 Thread Peter Eisentraut
Log Message: --- Update expected files for textual changes Modified Files: -- pgsql/src/interfaces/ecpg/test/expected: compat_informix-test_informix.stderr (r1.5 -> r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/co