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
