On Sun, 28 Oct 2001 00:33:07 -0700, you wrote:
>I'm used to just doing the insert and catching the SQLCODE -803
>on DB2 to know that the row I'm trying to insert already exists.
>
>Is there an easy way to do this using Postgresql and JDBC?
I'm afraid not.
"SQLException.getErrorCode() always returns 0. The PostgreSQL
backend currently doesn't provide error codes. This issue is on
the TODO list (Admin: 'Allow elog() to return error codes').
Once it is fixed in the backend and the FE/BE protocol, it can
be fixed in the JDBC driver as well."
http://lab.applinet.nl/postgresql-jdbc/#SQLException
Regards,
René Pijlman <rene@lab.applinet.nl>