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@xxxxxxxxxxx
