[GENERAL] UNIQUE_VIOLATION, Finding out which index would have been violated

2007-09-26 Thread Petri Simolin
Greetings list, I have created a function which inserts a row in a table which has 2 unique indexes on two different columns. I was wondering if there is a way in case of UNIQUE_VIOLATION exception to find out which index would have been violated? Petri Simolin

[GENERAL] UNIQUE_VIOLATION exception, finding out which ind ex would have been violated

2007-09-24 Thread Petri Simolin
Greetings list, 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? Petri Simolin