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 f21J6ax76995 for ; Thu, 1 Mar 2001 14:06:36 -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 LAA07539 for ; Thu, 1 Mar 2001 11:06:32 -0800 Message-ID: <02df01c0a282$c352b700$5a2b7ad8@expertrade.com> Reply-To: "David Wall" From: "David Wall" To: References: Subject: Re: JDBC error codes to detect duplicates? Date: Thu, 1 Mar 2001 11:06:47 -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/7 X-Sequence-Number: 1168 > 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. Thoughts? David