UNIQUE_VIOLATION, Finding out which index would have been violated

Поиск
Список
Период
Сортировка
От Petri Simolin
Тема UNIQUE_VIOLATION, Finding out which index would have been violated
Дата
Msg-id 7d38f174e0790e19597486f00f088974@mail.petrisimolin.com
обсуждение исходный текст
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Conal
Дата:
Сообщение: Poor performance with ON DELETE CASCADE
Следующее
От: Dan99
Дата:
Сообщение: Re: PG_DUMP not working