Thread: ERROR: Cannot insert a duplicate key into a unique index

[SQL] ERROR:  Cannot insert a duplicate key into a unique index

I'm working on a C code application using loads of 
insert commands. 
It is essential to distinguish between an error 
coming from a misformed command or other fatal 
reasons and a duplicate key. 
In either case, the PQresultStatus() returns 
PGRES_FATAL_ERROR
I can check PQresultErrorMessage() for the 
error message above, but then I have to rely 
on this string never be changed. 
This is no good programming style. 
Does anybody have another, better idea or is 
there at least a header file available, where 
all the error messages can be found? 

Regards, Christoph

Christoph,

> This is no good programming style. 
> Does anybody have another, better idea or is 
> there at least a header file available, where 
> all the error messages can be found? 

Try posting this question to pgsql-hackers instead.  I think you'll get
more knowledgable help there.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco