How to tell why an insert failed? - Mailing list pgsql-general

From Jeremy Cowgar
Subject How to tell why an insert failed?
Date
Msg-id 1025037401.2149.1.camel@dsktop
Whole thread Raw
In response to Re: Proxy Server ...  ("Marc G. Fournier" <scrappy@hub.org>)
Responses Re: How to tell why an insert failed?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
In C I would like to tell if an insert failed and why. In particular if
it failed because of a duplicate value in a field marked unique.

Can this be done, how? If not, is their a work around besides querying
each unique field for a dup?

Thanks,

Jeremy





pgsql-general by date:

Previous
From: "Tom Burke"
Date:
Subject: Re: indexes greatly slowing data entry
Next
From: "William N. Zanatta"
Date:
Subject: Re: Help with Arrays and References