Is there a "better" way to test for duplicate rows than by first do a
select to see if the key already exists?
Henry D.

Rene Pijlman wrote:

> 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."
> Regards,
> René Pijlman <[EMAIL PROTECTED]>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

Reply via email to