Re: JDBC error codes to detect duplicates?

At 11:06 01/03/01 -0800, David Wall wrote:
> > 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)
>
>Too bad.  Is the definitive list of error messages documented? (Probably
>yes, but where?)  Perhaps we could write an ugly implementation that would
>parse the error message and return meaningful errors codes so that all users
>don't suffer the same problem.

problem is two fold:

1: Enlarges the driver, which affects those who use the driver over a 
network connection (some people still use JDBC direct in applets)

2: It becomes sensitive to changes during development.

An example of  #2 is where the Timestamp format changed just slightly, then 
getTimestamp broke.

Peter