[COMMITTERS] psqlodbc - psqlodbc: The version is now 8.2.0402.

2007-06-01 Thread User Hinoue
Log Message: --- The version is now 8.2.0402. . Fix some bugs in case without MSDTC support. . Refine the realloc handling. . Put back the @@IDENTITY implementation so as not to use lastval(). . Change SQLColumns() to return correct column length in the Unicode driver. . Remove the connect

[COMMITTERS] pgsql: TODO item not needed anymore now that the buffer cache is

2007-06-01 Thread Bruce Momjian
Log Message: --- TODO item not needed anymore now that the buffer cache is scan-resistant: < < * Allow free-behind capability for large sequential scans, perhaps using < posix_fadvise() < < Posix_fadvise() can control both sequential/random file caching and < free-behind behavior,

[COMMITTERS] pgsql: Improve efficiency of LIKE/ILIKE code, especially for multi-byte

2007-06-01 Thread Andrew Dunstan
Log Message: --- Improve efficiency of LIKE/ILIKE code, especially for multi-byte charsets, and most especially for UTF8. Remove unnecessary special cases for bytea processing and single-byte charset ILIKE. a ILIKE b is now processed as lower(a) LIKE lower(b) in all cases. The code is now

[COMMITTERS] pgsql: Fix aboriginal bug in BufFileDumpBuffer that would cause it to

2007-06-01 Thread Tom Lane
Log Message: --- Fix aboriginal bug in BufFileDumpBuffer that would cause it to write the wrong data when dumping a bufferload that crosses a component-file boundary. This probably has not been seen in the wild because (a) component files are normally 1GB apiece and (b) non-block-aligned bu

[COMMITTERS] pgsql: Fix aboriginal bug in BufFileDumpBuffer that would cause it to

2007-06-01 Thread Tom Lane
Log Message: --- Fix aboriginal bug in BufFileDumpBuffer that would cause it to write the wrong data when dumping a bufferload that crosses a component-file boundary. This probably has not been seen in the wild because (a) component files are normally 1GB apiece and (b) non-block-aligned bu

[COMMITTERS] pgsql: Fix aboriginal bug in BufFileDumpBuffer that would cause it to

2007-06-01 Thread Tom Lane
Log Message: --- Fix aboriginal bug in BufFileDumpBuffer that would cause it to write the wrong data when dumping a bufferload that crosses a component-file boundary. This probably has not been seen in the wild because (a) component files are normally 1GB apiece and (b) non-block-aligned bu

[COMMITTERS] pgsql: Fix aboriginal bug in BufFileDumpBuffer that would cause it to

2007-06-01 Thread Tom Lane
Log Message: --- Fix aboriginal bug in BufFileDumpBuffer that would cause it to write the wrong data when dumping a bufferload that crosses a component-file boundary. This probably has not been seen in the wild because (a) component files are normally 1GB apiece and (b) non-block-aligned bu

[COMMITTERS] pgsql: Fix aboriginal bug in BufFileDumpBuffer that would cause it to

2007-06-01 Thread Tom Lane
Log Message: --- Fix aboriginal bug in BufFileDumpBuffer that would cause it to write the wrong data when dumping a bufferload that crosses a component-file boundary. This probably has not been seen in the wild because (a) component files are normally 1GB apiece and (b) non-block-aligned bu

[COMMITTERS] pgsql: Fix aboriginal bug in BufFileDumpBuffer that would cause it to

2007-06-01 Thread Tom Lane
Log Message: --- Fix aboriginal bug in BufFileDumpBuffer that would cause it to write the wrong data when dumping a bufferload that crosses a component-file boundary. This probably has not been seen in the wild because (a) component files are normally 1GB apiece and (b) non-block-aligned bu

[COMMITTERS] pgsql: Allow leading and trailing whitespace in the input to the boolean

2007-06-01 Thread Neil Conway
Log Message: --- Allow leading and trailing whitespace in the input to the boolean type. Also, add explicit casts between boolean and text/varchar. Both of these changes are for conformance with SQL:2003. Update the regression tests, bump the catversion. Modified Files: --

[COMMITTERS] pgunittest - pgUnitTest:

2007-06-01 Thread User Pgunittest
Log Message: --- Modified Files: -- pgUnitTest: INSTALL (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest/INSTALL.diff?r1=1.1&r2=1.2) pgUnitTest/usr/uml/diagrams: design.txt (r1.1 -> r1.2) (http://cvs.pg

[COMMITTERS] pgunittest - pgUnitTest:

2007-06-01 Thread User Pgunittest
Log Message: --- Modified Files: -- pgUnitTest/src/org/pgfoundry/pgunittest: PGUnitTest.java (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest/src/org/pgfoundry/pgunittest/PGUnitTest.java.diff?r1=1.4&r2=1.5) Added Files: --

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-01 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/specs In directory pgfoundry.org:/tmp/cvs-serv83440/usr/specs Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/specs added to the repository ---(end of broadcast)--- TIP 4: Have you searched our

[COMMITTERS] pgsql: Make CREATE/DROP/RENAME DATABASE wait a little bit to see if

2007-06-01 Thread Tom Lane
Log Message: --- Make CREATE/DROP/RENAME DATABASE wait a little bit to see if other backends will exit before failing because of conflicting DB usage. Per discussion, this seems a good idea to help mask the fact that backend exit takes nonzero time. Remove a couple of thereby-obsoleted sl

[COMMITTERS] pgsql: Add URL for: o Research self-referential UPDATEs that

2007-06-01 Thread Bruce Momjian
Log Message: --- Add URL for: o Research self-referential UPDATEs that see inconsistent row versions in read-committed mode < > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00016.php Modified Files: -- pgsql/doc: TODO (r1.2196

[COMMITTERS] pgsql: Update wording: o Research self-referential UPDATEs that

2007-06-01 Thread Bruce Momjian
Log Message: --- Update wording: o Research self-referential UPDATEs that see inconsistent row versions in read-committed mode http://archives.postgresql.org/pgsql-hackers/2007-05/msg00507.php Modified Files: -- pgsql/doc: TODO (r1.2195

[COMMITTERS] pgsql: Buy back some of the cycles spent in more-expensive hash

2007-06-01 Thread Tom Lane
Log Message: --- Buy back some of the cycles spent in more-expensive hash functions by selecting power-of-2, rather than prime, numbers of buckets in hash joins. If the hash functions are doing their jobs properly by making all hash bits equally random, this is good enough, and it saves exp

[COMMITTERS] pgsql: Fix performance problems in multi-batch hash joins by ensuring

2007-06-01 Thread Tom Lane
Log Message: --- Fix performance problems in multi-batch hash joins by ensuring that we select a well-randomized batch number even when given a poorly-randomized hash value. This is a bit inefficient but seems the only practical solution given the constraint that we can't change the hash fu

[COMMITTERS] pgsql: Fix performance problems in multi-batch hash joins by ensuring

2007-06-01 Thread Tom Lane
Log Message: --- Fix performance problems in multi-batch hash joins by ensuring that we select a well-randomized batch number even when given a poorly-randomized hash value. This is a bit inefficient but seems the only practical solution given the constraint that we can't change the hash fu

[COMMITTERS] pgsql: Fix several hash functions that were taking chintzy shortcuts

2007-06-01 Thread Tom Lane
Log Message: --- Fix several hash functions that were taking chintzy shortcuts instead of delivering a well-randomized hash value. I got religion on this after observing that performance of multi-batch hash join degrades terribly if the higher-order bits of hash values aren't random, as in

[COMMITTERS] pgunittest - pgUnitTest:

2007-06-01 Thread User Pgunittest
Log Message: --- Added Files: --- pgUnitTest/usr/uml/pgUnitTest: 131745.bodies (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest/usr/uml/pgUnitTest/131745.bodies?rev=1.1&content-type=text/x-cvsweb-markup) 128033.diagram (r1.1)

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-01 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/uml/diagrams In directory pgfoundry.org:/tmp/cvs-serv36824/usr/uml/diagrams Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/uml/diagrams added to the repository ---(end of broadcast)--- TIP 2:

[COMMITTERS] pgunittest - pgUnitTest: New Directory

2007-06-01 Thread User Pgunittest
Update of /cvsroot/pgunittest/pgUnitTest/usr/uml/pgUnitTest In directory pgfoundry.org:/tmp/cvs-serv36824/usr/uml/pgUnitTest Log Message: Directory /cvsroot/pgunittest/pgUnitTest/usr/uml/pgUnitTest added to the repository ---(end of broadcast)---