The following bug has been logged online:

Bug reference: 2593
Logged by: Igor Urisman
Email address: igor.urisman (AT) gmail (DOT) com
PostgreSQL version: 8.1.3
Operating system: Windows
Description: Improper implimentation of SQLException
Details:

The vendor error code is returned in getSQLState(), instead of getError().
At least this is the case for 23505 (ERROR: duplicate key violates unique
constraint ...)
Cheers.
Igor Urisman,
Berkeley, Ca, U.S.A.
P.S. Enjoying Postgres immensly. Thanks for the great job.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Sun, 27 Aug 2006, Igor Urisman wrote:

Postgresql does not have specific vendor error codes and always returns 0
for SQLException.getErrorCode(). Postgresql uses standard SQL State
values only. These often have characters in them so they cannot also be
returned as the vendor error code.

Perhaps the problem is that this page is referring to error codes when a
more careful reading shows that it is really talking about sql state
values?

http://www.postgresql.org/docs/curre...-appendix.html

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org