Re: Trouble referencing a multi-column unique constraint by name in ON CONFLICT clause

2018-09-27 Thread Charles Leifer
Many thanks, sorry for missing something so obvious! On Thu, Sep 27, 2018 at 1:45 PM, Tom Lane wrote: > Charles Leifer writes: > > I'm running into behavior I don't understand when trying to do an UPSERT > > with Postgres. The docs would seem to indicate that the conflict target > of > > the IN

Re: Trouble referencing a multi-column unique constraint by name in ON CONFLICT clause

2018-09-27 Thread Tom Lane
Charles Leifer writes: > I'm running into behavior I don't understand when trying to do an UPSERT > with Postgres. The docs would seem to indicate that the conflict target of > the INSERT statement can be either an index expression or a constraint > name. However, when attempting to reference the

Trouble referencing a multi-column unique constraint by name in ON CONFLICT clause

2018-09-27 Thread Charles Leifer
Hi, I'm running into behavior I don't understand when trying to do an UPSERT with Postgres. The docs would seem to indicate that the conflict target of the INSERT statement can be either an index expression or a constraint name. However, when attempting to reference the constraint name, I get a "c