multiple conflict targets - Mailing list pgsql-general

From Torsten Förtsch
Subject multiple conflict targets
Date
Msg-id CAKkG4_m_EMZ5Rbfk8CY5P5JdGoupRVWh2STXE=dU+Lqs=E3uqw@mail.gmail.com
Whole thread Raw
Responses Re: multiple conflict targets
List 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 by date:

Previous
From: Adrien NAYRAT
Date:
Subject: Re: Postgres - search for value throughout many tables?
Next
From: "Daniel Verite"
Date:
Subject: Re: Postgres - search for value throughout many tables?