"duplicate key value": version 8.4 vs 8.1
От | mountain oaf |
---|---|
Тема | "duplicate key value": version 8.4 vs 8.1 |
Дата | |
Msg-id | AANLkTinFN4cT+D0jy4RaizPE4h5k82g=+jJg2MWeaxsA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: "duplicate key value": version 8.4 vs 8.1
Re: "duplicate key value": version 8.4 vs 8.1 |
Список | pgsql-novice |
Hello, I am a Postgres newbie using a C program to add records to a Postgres database. When I run it against an 8.4.4 version of Postgres, data inserted into a table which violate an unique index are reported back to the program via sqlca.sqlcode as -403 ('duplicate key value violates unique constraint "my_index"'). However, when I run the same program against an 8.1.2 database, the error isn't trapped. I'm explicitly looking for a -403 code via sqlca.sqlcode so am assuming that the error code is different in this version of the database. I've had a look on Teh Interwebs around to try and find out what the equivalent code is for 8.1.2 but have had no success so far. Could anyone point me in the right direction, please? Thanks in advance for any assistance, Mark
В списке pgsql-novice по дате отправления: