Skip site navigation (1) Skip section navigation (2)

Re: duplicate key violates unique constraint

From: "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>
To: "Teemu Torma" <teemu(at)torma(dot)org>,<pgsql-sql(at)postgresql(dot)org>
Subject: Re: duplicate key violates unique constraint
Date: 2008-02-26 16:05:01
Message-ID: 016401c87891$58237950$3102a8c0@dream (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)torma(dot)org>
To: <pgsql-sql(at)postgresql(dot)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 


In response to

Responses

pgsql-sql by date

Next:From: Andrew SullivanDate: 2008-02-26 16:22:46
Subject: Re: duplicate key violates unique constraint
Previous:From: Teemu TormaDate: 2008-02-26 15:17:39
Subject: Re: duplicate key violates unique constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group