How to tell why an insert failed?

From: Jeremy Cowgar <develop(at)cowgar(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to tell why an insert failed?
Date: 2002-06-25 20:36:40
Message-ID: 1025037401.2149.1.camel@dsktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William N. Zanatta 2002-06-25 20:46:30 Re: Help with Arrays and References
Previous Message Eric 2002-06-25 20:16:05 Re: indexes greatly slowing data entry