On Sun, Apr 26, 2015 at 2:22 AM, Heikki Linnakangas <hlinn...@iki.fi> wrote: > The ability to specify a constraint by name hasn't been implemented, but > that would read quite naturally as: > > INSERT INTO mytable ON CONFLICT ON CONSTRAINT my_constraint UPDATE ...
For the record, I have made this change on Github (Andres and I have been doing a lot of clean-up. I point this change in particular out because it's a behavioral change). The INSERT documentation has been updated to reflect this, and includes an example. This copy of the documentation is current: http://postgres-benchmarks.s3-website-us-east-1.amazonaws.com/on-conflict-docs/sql-insert.html -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers