On Tue, Sep 25, 2007 at 04:55:37AM -0200, Petri Simolin wrote: > I have created a function which inserts a row in a table which has 2 unique > indexes on two different columns. > > I am wondering, if there is a way in case of UNIQUE_VIOLATION exception to > find out which index would have been violated?
In PL/pgSQL you could extract the constraint name from SQLERRM, which should be a string like 'duplicate key violates unique constraint "foo_id1_key"'. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
