On 2015-05-20 17:44:05 +0100, Thom Brown wrote: > On 8 May 2015 at 16:03, Andres Freund <and...@anarazel.de> wrote: > > So I've committed the patch yesterday evening. I'm pretty sure there'll > > be some more minor things to change. But overall I feel good about the > > current state. > > > > It'd be quite helpful if others could read the docs, specifically for > > insert, and comment whether they're understandable. I've spent a fair > > amount of time trying to make them somewhat simpler, but I do think I > > only succeeded partially. And there's also my own brand of english to > > consider ;) > > The docs say "Note that exclusion constraints are not supported with > ON CONFLICT DO UPDATE." > > But I get the following error message text: > > "ERROR: there is no unique or exclusion constraint matching the ON > CONFLICT specification" > > This implies that an exclusion constraint is valid in the statement, > which contradicts the docs. Which one is correct?
ON CONFLICT can be used for ... DO NOTHING as well. Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
