From: | "Ravi" <Ravindra-Prasad(at)worldnet(dot)att(dot)net> |
---|---|
To: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | postgre and sqlerror handling |
Date: | 1999-11-08 19:51:55 |
Message-ID: | 000d01bf2a22$c5ac95e0$4f619ca7@npgm063.chubb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hello All
I am using postgresql in a 'C' program running on Linux. It's a simple program which inserts a row. This insert should give error. However in spite of me having error handling when I run this program it generates hundreds of the following error message:
"cannot insert duplicate key into a unique index
NOTICE: UserAbortTransactionBlock and not in in-progress state."
I do not know why it does not use err handler and stop after first error.
2) Also when I use goto err_handler in my code it gives compile error. Can ayone suggets the correct syntax.
Thanks All
Ravi
From | Date | Subject | |
---|---|---|---|
Next Message | Zubair Saifullah | 1999-11-08 23:25:16 | jdbc Driver |
Previous Message | Coleman, Andrew | 1999-11-08 16:39:12 | [INTERFACES] my problems with ecpg and arrays |