Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0
Date
Msg-id 4724.1432144500@sss.pgh.pa.us
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Andres Freund <andres@anarazel.de> writes:
> On 2015-05-20 13:31:57 -0400, Tom Lane wrote:
>> If you can't use an exclusion constraint to support the command,
>> then the error message shouldn't be worded like that.

> But you *can* use a exclusion constraint for DO NOTHING. Just not (yet)
> for DO UPDATE.

Hm.  Maybe it would be worth having two different message texts for
the two cases, then?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Typo patch
Next
From: Alvaro Herrera
Date:
Subject: Re: Disabling trust/ident authentication configure option