On Tue, Feb 7, 2017 at 2:15 PM, Tiago Babo <tiago(dot)babo(at)gmail(dot)com> wrote:
> Here is an example where it gives the error (I excluded the created_at and
> updated_at columns in the last e-mail, but they do exist in the table):
>
> INSERT INTO accounts (type, person_id) VALUES ('PersonAccount', 69559,
> '2017-02-03 12:09:27.259', '2017-02-03 12:09:27.259') ON CONFLICT (type,
> person_id) WHERE type = 'PersonAccount' DO UPDATE SET updated_at =
> EXCLUDED.updated_at RETURNING *
Can you give an example of where it does actually work? Is there any
discernible pattern to what each case looks like?
--
Peter Geoghegan