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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq