Re: multiple conflict targets

2018-08-10 Thread 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 no

multiple conflict targets

2018-08-10 Thread 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