From: David Wall <d.wall@computer.org>
To: Max Khon <fjoe@iclub.nsu.ru>
To: Peter Mount <peter@retep.org.uk>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: JDBC error codes to detect duplicates?
Date: Thu, 1 Mar 2001 14:08:47 -0800
Message-ID: <003701c0a29c$304b1a00$5a2b7ad8@expertrade.com> (raw)
References: <017801c0a27c$4b0902a0$5a2b7ad8@expertrade.com>
<5.0.2.1.0.20010301210608.0222ab40@mail.retep.org.uk>
> >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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: d.wall@computer.org, fjoe@iclub.nsu.ru, peter@retep.org.uk
Subject: Re: JDBC error codes to detect duplicates?
In-Reply-To: <003701c0a29c$304b1a00$5a2b7ad8@expertrade.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox