Re: JDBC error codes to detect duplicates?

Quoting Max Khon <fjoe@iclub.nsu.ru>:

> hi, there!
> 
> On Thu, 1 Mar 2001, Peter Mount wrote:
> 
> > > > It seems that when an INSERT causes a duplicate key exception for
> > > > unique/primary keys, the JDBC library is throwing the SQL
> exception but
> > > > there is no code that lets my program detect a duplicate key
> error, or 
> > > which
> > > > key caused the duplicate error.
> > > >
> > > > Is there a plan for the JDBC to return the codes for postgres back
> to the
> > > > program?  I running 7.1beta4 now.
> > >
> > >AFAIK clean implementation of such feature is not possible because
> backend
> > >protocol does not have error codes (only error messages)
> > 
> > Thats correct. It's also not practical to get the driver to translate
> 
> > because the format of the messages can change between releases as
> well.
> 
> can we consider adding error code prepended to error message and
> separated with e.g. one single space? seems that this will not break
> anything but will allow JDBC/ODBC drivers to return meaningful error
> codes.

That is the other alternative, and one that could be implemented pretty quickly.

Peter

-- 
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/