Received: from mtiwmhc01.worldnet.att.net (mtiwmhc01.worldnet.att.net [204.127.131.36]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA68078 for ; Mon, 8 Nov 1999 15:05:08 -0500 (EST) (envelope-from Ravindra-Prasad@worldnet.att.net) Received: from npgm063 ([12.20.42.137]) by mtiwmhc01.worldnet.att.net (InterMail v03.02.07.07 118-134) with SMTP id <19991108194758.QQTF26289@npgm063> for ; Mon, 8 Nov 1999 19:47:58 +0000 Message-ID: <000d01bf2a22$c5ac95e0$4f619ca7@npgm063.chubb.com> From: "Ravi" To: Subject: postgre and sqlerror handling Date: Mon, 8 Nov 1999 14:51:55 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01BF29F8.CCAAFF50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01BF29F8.CCAAFF50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello All =20 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=20 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 ------=_NextPart_000_000A_01BF29F8.CCAAFF50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello All

I am using postgresql in a = 'C' program=20 running on Linux. It's a simple program which inserts a row. This insert = should=20 give error. However in spite of me having error handling when I run this = program=20 it generates hundreds of the following error message:

"cannot insert duplicate key = into a unique=20 index

NOTICE: = UserAbortTransactionBlock and not=20 in in-progress state."

I do not know why it does not use = err handler=20 and stop after first error.

2) Also when I use goto err_handler = in my code=20 it gives compile error. Can ayone suggets the correct = syntax.

Thanks All

Ravi

------=_NextPart_000_000A_01BF29F8.CCAAFF50--