From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: MERGE SQL Statement for PG11 |
Date: | 2017-11-02 02:58:33 |
Message-ID: | CAMsr+YHB1fpgF8UOpV+_65ZbwWf7xjaQR_EP+faaUXG3QBidCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 1 November 2017 at 01:55, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> The problem here is: Iff the first statement uses ON CONFLICT
> infrastructure, doesn't the absence of WHEN NOT MATCHED imply
> different semantics for the remaining updates and deletes in the
> second version of the query? You've removed what seems like a neat
> adjunct to the MERGE, but it actually changes everything else too when
> using READ COMMITTED.
Would these concerns be alleviated by adding some kind of Pg-specific
decoration that constrained concurrency-safe MERGEs?
So your first statement would be
MERGE CONCURRENTLY ...
and when you removed the WHEN NOT MATCHED clause it'd ERROR because
that's no longer able to be done with the same concurrency-safe
semantics?
I don't know if this would be helpful TBH, or if it would negate
Simon's compatibility goals. Just another idea.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | 高增琦 | 2017-11-02 03:07:29 | Re: Try to fix endless loop in ecpg with informix mode |
Previous Message | Robert Haas | 2017-11-02 02:56:57 | Re: WIP: long transactions on hot standby feedback replica / proof of concept |