Thread: Error Messages / Codes in DBD / JDBC

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

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   |
+------------------------------+---------------------------------------------+