Re: JDBC error codes to detect duplicates? - Mailing list pgsql-interfaces

From Bruce Momjian
Subject Re: JDBC error codes to detect duplicates?
Date
Msg-id 200103012254.RAA25630@candle.pha.pa.us
Whole thread Raw
In response to Re: JDBC error codes to detect duplicates?  ("David Wall" <d.wall@computer.org>)
Responses Re: JDBC error codes to detect duplicates?  (Cedar Cox <cedarc@visionforisrael.com>)
Re: JDBC error codes to detect duplicates?  (Max Khon <fjoe@iclub.nsu.ru>)
List pgsql-interfaces
I have ideas on how to do error codes and multiple languages.  I can
make a proposal for 7.2.

[ Charset ISO-8859-1 unsupported, converting... ]
> > >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.
> 
> Practically speaking, how often do the messages really change between
> releases?  It seems that we could create a pluggable translator that would
> work based on the release version.  If the messages change too frequently,
> then something's seriously wrong with Postgresql server since the main
> sql-portion of the system has been in place and there aren't too many things
> a program really needs to detect about a database (missing row, duplicate
> key, constraint violation, transaction error, deadlock detected, etc.).
> 
> David
> 
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-interfaces by date:

Previous
From: "David Wall"
Date:
Subject: Re: JDBC error codes to detect duplicates?
Next
From: Cedar Cox
Date:
Subject: Re: JDBC error codes to detect duplicates?