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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]