From: Peter Mount <peter@retep.org.uk>
To: Max Khon <fjoe@iclub.nsu.ru>
To: David Wall <d.wall@computer.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: JDBC error codes to detect duplicates?
Date: Thu, 01 Mar 2001 21:07:01 +0000
Message-ID: <5.0.2.1.0.20010301210608.0222ab40@mail.retep.org.uk> (raw)
In-Reply-To: <Pine.BSF.4.21.0103020041110.98084-100000@iclub.nsu.ru>
References: <017801c0a27c$4b0902a0$5a2b7ad8@expertrade.com>
At 00:41 02/03/01 +0600, Max Khon wrote:
>hi, there!
>
>On Thu, 1 Mar 2001, David Wall 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.
Peter
>/fjoe
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: peter@retep.org.uk, fjoe@iclub.nsu.ru, d.wall@computer.org
Subject: Re: JDBC error codes to detect duplicates?
In-Reply-To: <5.0.2.1.0.20010301210608.0222ab40@mail.retep.org.uk>
* 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