Re: duplicate key violates unique constraint
От | Shavonne Marietta Wijesinghe |
---|---|
Тема | Re: duplicate key violates unique constraint |
Дата | |
Msg-id | 016401c87891$58237950$3102a8c0@dream обсуждение исходный текст |
Ответ на | duplicate key violates unique constraint ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>) |
Ответы |
Re: duplicate key violates unique constraint
Re: duplicate key violates unique constraint |
Список | pgsql-sql |
Thank you. I tried as you said. But i get a ERROR: syntax error at or near "INSERT" at character 9 BEGININSERT INTO my_shevi values ('a', 4, 2, 2); EXCEPTIONWHEN unique_violation THENINSERT 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
В списке pgsql-sql по дате отправления: