multiple conflict targets

Поиск
Список
Период
Сортировка
От Torsten Förtsch
Тема multiple conflict targets
Дата
Msg-id CAKkG4_m_EMZ5Rbfk8CY5P5JdGoupRVWh2STXE=dU+Lqs=E3uqw@mail.gmail.com
обсуждение исходный текст
Ответы Re: multiple conflict targets
Список pgsql-general
Hi,

if I read https://www.postgresql.org/docs/9.6/static/sql-insert.html correctly there can be only one conflict target or none at all.

What if I have a table with 3 unique constraints? If the first one is violated by the insert I want to do nothing. If the 2nd is violated some fields should be updated. And violation of the 3rd one should raise an error.

Can that be expressed?

Thanks,
Torsten

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