From: | Peter Geoghegan <pg(at)heroku(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Anssi Kääriäinen <anssi(dot)kaariainen(at)thl(dot)fi>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Craig Ringer <craig(at)2ndquadrant(dot)com> |
Subject: | Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} |
Date: | 2014-11-27 00:59:39 |
Message-ID: | CAM3SWZQO9F4PO09dzt1oNoOC1=k5JC=yvwTA2gcinxXhLN3AJw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Nov 24, 2014 at 1:03 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> Looks like the consensus is that we should have RETURNING project
> updated tuples too, then.
Attached revision, v1.5, establishes this behavior (as always, there
is a variant for each approach to value locking). There is a new
commit with a commit message describing the new RETURNING/command tag
behavior in detail, so no need to repeat it here. The documentation
has been updated in these areas, too.
There is also one or two tiny comment tweaks here and there, as well
as a pg_proc OID collision fix in the case of the value locking
approach #1 variant.
My mirror of the documentation (i.e. a html build) has been updated.
INSERT command documentation (for new RETURNING behavior):
http://postgres-benchmarks.s3-website-us-east-1.amazonaws.com/on-conflict-docs/sql-insert.html
Details of changes to command tag:
I'll make a pass at the Wiki page to reflect these changes soon.
--
Peter Geoghegan
Attachment | Content-Type | Size |
---|---|---|
v1.5.vallock2.tar.gz | application/x-gzip | 77.2 KB |
v1.5.vallock1.tar.gz | application/x-gzip | 90.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2014-11-27 01:16:57 | Re: Add CREATE support to event triggers |
Previous Message | Andrew Dunstan | 2014-11-27 00:24:02 | Re: memory explosion on planning complex query |