Обсуждение: multiple conflict targets

Поиск
Список
Период
Сортировка

multiple conflict targets

От
Torsten Förtsch
Дата:
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

Re: multiple conflict targets

От
Adrian Klaver
Дата:
On 08/10/2018 03:12 AM, Torsten Förtsch wrote:
> 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?

Yes as a trigger and associated function.

> 
> Thanks,
> Torsten


-- 
Adrian Klaver
adrian.klaver@aklaver.com