By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,693 Members | 1,972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,693 IT Pros & Developers. It's quick & easy.

Java / Perl Return codes

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.