Received: from mail1.expertrade.com (r87-43-dsl.sea.lightrealm.net
	[216.122.43.87])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f21IKFx71047
	for <pgsql-interfaces@postgresql.org>;
	Thu, 1 Mar 2001 13:20:16 -0500 (EST)
	(envelope-from d.wall@computer.org)
Received: from reggae (reggae.expertrade.com [216.122.43.90])
	by mail1.expertrade.com (8.9.3/8.9.3) with SMTP id KAA07390
	for <pgsql-interfaces@postgresql.org>; Thu, 1 Mar 2001 10:20:14 -0800
Message-ID: <017801c0a27c$4b0902a0$5a2b7ad8@expertrade.com>
Reply-To: "David Wall" <d.wall@computer.org>
From: "David Wall" <d.wall@computer.org>
To: <pgsql-interfaces@postgresql.org>
References: <876C89678A051145876D939BF4B7A82C0B56CB@net1.hq.nethouse.it>
Subject: JDBC error codes to detect duplicates?
Date: Thu, 1 Mar 2001 10:20:28 -0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Archive-Number: 200103/5
X-Sequence-Number: 1166

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.

David