Re: Error Messages / Codes in DBD / JDBC
От | Paul Thomas |
---|---|
Тема | Re: Error Messages / Codes in DBD / JDBC |
Дата | |
Msg-id | 20031031143844.A7547@bacon обсуждение исходный текст |
Ответ на | Error Messages / Codes in DBD / JDBC (Alex <alex@meerkatsoft.com>) |
Список | pgsql-general |
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 | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: