the redhat patch for SQLState support.

 Added Files:
 	PSQLState.java

support to the jdbc driver.
That patch needed some work: it assumed the sqlcode in a server message was
fixed in its position, the patch lost the ability to pass exceptions, and the
patch missed a couple of places where server errors where being received.
In addition to fixing the above, I also added full support for the V3 protocol
error message syntax, I reversed the order of arguments in the PSQLException
constructor to more closely follow the constructors for SQLException, I changed
the new constructors that take PSQLState to take Object for additional
parameters as the old ones did.
Still todo are to add SQLState values to all existing exceptions thrown in the
driver and add support for parsing the V3 protocol format for notices.

 Modified Files:
 	jdbc/build.xml jdbc/org/postgresql/Driver.java.in
 	jdbc/org/postgresql/errors.properties
 	jdbc/org/postgresql/core/Encoding.java
 	jdbc/org/postgresql/core/PGStream.java
 	jdbc/org/postgresql/core/QueryExecutor.java
 	jdbc/org/postgresql/fastpath/Fastpath.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
 	jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
 	jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
 	jdbc/org/postgresql/util/MessageTranslator.java
 	jdbc/org/postgresql/util/PSQLException.java

system headers on Unixware.

sequence every time it's called is bogus --- it interferes with user
control over the seed, and actually decreases randomness overall
(because a seed based on time(NULL) is pretty predictable).  If you really
want a reproducible result from geqo, do 'set seed = 0' before planning
a query.

by recent IPv6 changes, and since it's redundant with a kernel-level check
anyway, it seems not worth trying to fix it.  Per recent discussions.

        o allow configure to see include/port/win32 include files
        o add matching Win32 accept() prototype
        o allow pg_id to compile with native Win32 API
        o fix invalide mbvalidate() function calls (existing bug)
        o allow /scripts to compile with native Win32 API
        o add win32.c to Win32 compiles (already in *.mak files)

set HAVE_IPV6.  Per recent discussions.

on either name or inode; otherwise load_external_function() won't do
anything.  At least on Linux, it appears that recompiling a shlib leads
to a new file with a different inode, so the old code failed to detect
a match.

error.  There is no point in providing some kind of forward compatibility
now, because no one can tell what a future implementation will look like.

returned by getaddrinfo_all will have enough room for an IPv6 address.

that have IPv4-embedded-in-IPv6 addresses.  Per idea of Andreas Pflug.

< * Allow psql to do table completion for SELECT * FROM schema_part and
> * -Allow psql to do table completion for SELECT * FROM schema_part and

Needed for libpq builds, not just for native Win32 port, and probably
for cygwin too.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)

Andrew Dunstan

> * Maintain a map of recently-expired of pages so vacuum can reclaim
>   free space without a sequential scan

> * -Improve concurrency of hash indexes (Tom)

platform.

Andreas Pflug

> 	o Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME

<
> * Print table names with constraint names in error messages, or make constraint
>   names unique within a schema

pghackers.  This fixes the problem recently reported by Markus KrÌutner
(hash bucket split corrupts the state of scans being done concurrently),
and I believe it also fixes all the known problems with deadlocks in
hash index operations.  Hash indexes are still not really ready for prime
time (since they aren't WAL-logged), but this is a step forward.

grantees.

administrator has not turned it on, and fix other PGC_USERLIMIT
variables.

> * Allow to_char to print localized month names (Karel)

bound is valid but does nothing.

suggested by Richard Huxton <dev@archonet.com>