Re: [SQL] duplicate key violates unique constraint

2008-02-26 Thread Teemu Torma
On Tuesday 26 February 2008, Andrew Sullivan wrote: > Well, except that there's no "EXCEPTION" statement in SQL?  I think > your correspondent was intending for this to be programmatic. I was thinking pl/pgsql. Teemu ---(end of broadcast)--- TIP

Re: [SQL] duplicate key violates unique constraint

2008-02-26 Thread Teemu Torma
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