| 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: | Whole Thread | Raw Message | 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 |