DBD::Pg Err / Errstr

[Alex]

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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match