From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
Subject: Re: duplicate key violates unique constraint
Date: Tue, 26 Feb 2008 17:34:33 +0100
Message-ID: <47C44DA9.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <016401c87891$58237950$3102a8c0@dream>
References: <014401c87887$a8fed450$3102a8c0@dream>
<200802261617.39936.teemu@torma.org>
<016401c87891$58237950$3102a8c0@dream>
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:
>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, shavonne.marietta@studioform.it
Subject: Re: duplicate key violates unique constraint
In-Reply-To: <47C44DA9.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox