Thread: Java / Perl Return codes

Java / Perl Return codes

From
Alex P
Date:
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


Re: Java / Perl Return codes

From
Csaba Nagy
Date:
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