Message-Id: <5.0.2.1.0.20010301212711.00a4c030@mail.retep.org.uk>
Date: Thu, 01 Mar 2001 21:28:36 +0000
To: "David Wall" <d.wall@computer.org>, <pgsql-interfaces@postgresql.org>
From: Peter Mount <peter@retep.org.uk>
Subject: Re: JDBC error codes to detect duplicates?
In-Reply-To: <02df01c0a282$c352b700$5a2b7ad8@expertrade.com>
References: <Pine.BSF.4.21.0103020041110.98084-100000@iclub.nsu.ru>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

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