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

Error Messages / Codes in DBD / JDBC

P: n/a
Hi,
I am using DBD::Pg in some of my scripts. I want to customize the error
login based on the error received.
While I am happy with the Errstr message I want to take specific actions
depending on Errstr or Err.

Is there a list of all available error number (err) with associated
error message (errstr) that is produced by postgres?

Is there something similar for JDBC ?

I am particular interested in the errors for
- insert a duplicate key entry into unique index
- referential integrity violation

Thanks
Alex

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

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


P: n/a

On 31/10/2003 11:27 Alex wrote:
Hi,
I am using DBD::Pg in some of my scripts. I want to customize the error
login based on the error received.
While I am happy with the Errstr message I want to take specific actions
depending on Errstr or Err.

Is there a list of all available error number (err) with associated
error message (errstr) that is produced by postgres?

Is there something similar for JDBC ?

I am particular interested in the errors for
- insert a duplicate key entry into unique index
- referential integrity violation


Error numbers are in 7.4 :) And the JDBC driver will support them. For
versions 7.3 and below, I'm afraid that parsing the error string is the
only way.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.