Java / Perl Return codes

[Alex P]

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 ma*******@postgresql.org

[Csaba Nagy]

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 ma*******@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend