Re: Java / Perl Return codes - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Java / Perl Return codes
Date
Msg-id 1099666202.6361.84.camel@localhost.localdomain
Whole thread Raw
In response to Java / Perl Return codes  (Alex P <alex@meerkatsoft.com>)
List pgsql-general
Check out:
src/include/utils/errcodes.h
in the postgres source tree.
In Java you will get these error codes using the getSQLState method on
the SQLException. You should also check the JDBC source to any further
JDBC specific codes, as it is possible to have JDBC side errors (i.e.
not coming from the backend).
With perl I have no experience.

HTH,
Csaba.

On Fri, 2004-11-05 at 15:15, Alex P wrote:
> Hi,
> i would like to check for a given query (insert, update, delete) if
> there is a key or constraint violation which prevents the query from
> being executed.
>
> Is such a feature implemented in the perl or java drivers?
>
> If so, could anyone point to a list of available return codes?
>
> Thanks
> Alex
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-general by date:

Previous
From: Alex P
Date:
Subject: Java / Perl Return codes
Next
From: "Sally Sally"
Date:
Subject: VACUUM failing ??!!