Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A8A642E0039 for ; Tue, 26 Feb 2008 12:34:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61686-05 for ; Tue, 26 Feb 2008 12:34:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 74F1A2E0032 for ; Tue, 26 Feb 2008 12:34:44 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Tue, 26 Feb 2008 17:34:42 +0100 Message-Id: <47C44DA9.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Tue, 26 Feb 2008 17:34:33 +0100 From: "Bart Degryse" To: , "Shavonne Marietta Wijesinghe" Subject: Re: duplicate key violates unique constraint References: <014401c87887$a8fed450$3102a8c0@dream><200802261617.39936.teemu@torma.org><016401c87891$58237950$3102a8c0@dream> In-Reply-To: <016401c87891$58237950$3102a8c0@dream> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part5D7BD389.0__=" X-imss-version: 2.050 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/206 X-Sequence-Number: 30297 --=__Part5D7BD389.0__= Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Shavonne, You will probably always find someone on the list who will answer your questions, but you really should read the manual too! In this case you could have found the answer by reading http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING >>> "Shavonne Marietta Wijesinghe" 2008-02-26 17:05 >>> Thank you. I tried as you said. But i get a ERROR: syntax error at or near "INSERT" at character 9 BEGIN INSERT INTO my_shevi values ('a', 4, 2, 2); EXCEPTION WHEN unique_violation THEN INSERT INTO my_shevi values ('a', 5, 2, 2); END; I don't see anything wrong with the code.. Shavonne ----- Original Message ----- From: "Teemu Torma" To: Sent: Tuesday, February 26, 2008 4:17 PM Subject: Re: [SQL] duplicate key violates unique constraint > On Tuesday 26 February 2008, Shavonne Marietta Wijesinghe wrote: >> During an "INSERT INTO" I get an "Error - duplicate key violates >> unique constraint...." >> >> Is there any way, that i can test the error. Something like this?? >> >> IF error = "duplicate key violates unique constraint" then >> Â Â do something >> else >> Â Â insert into >> end if > > insert into ...; > exception when unique_violation then > do something; > > Teemu > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings --=__Part5D7BD389.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Description: HTML

Shavonne,

You will probably always find someone on the list who will answer your questions, but you really should read the manual too!

In this case you could have found the answer by reading

http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

>>> "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it> 2008-02-26 17:05 >>>
Thank you. I tried as you said. But i get a ERROR: syntax error at or near
"INSERT" at character 9

BEGIN
INSERT INTO my_shevi values ('a', 4, 2, 2);
EXCEPTION
WHEN unique_violation THEN
INSERT INTO my_shevi values ('a', 5, 2, 2);
END;

I don't see anything wrong with the code..

Shavonne

----- Original Message -----
From: "Teemu Torma" <teemu@torma.org>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, February 26, 2008 4:17 PM
Subject: Re: [SQL] duplicate key violates unique constraint

> On Tuesday 26 February 2008, Shavonne Marietta Wijesinghe wrote:
>& gt; During an "INSERT INTO" I get an "Error - duplicate key violates
>> unique constraint...."
>>
>> Is there any way, that i can test the error. Something like this??
>>
>> IF error = "duplicate key violates unique constraint" then
>> Â Â do something
>> else
>> Â Â insert into
>> end if
>
> insert into ...;
> exception when unique_violation then
> do something;
>
> Teemu
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--=__Part5D7BD389.0__=--