On Tue, Feb 7, 2017 at 2:15 PM, Tiago Babo <tiago.babo@gmail.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs