Re: [HACKERS] MERGE SQL Statement for PG11

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, Pavan Deolasee <pavan(dot)deolasee(at)2ndquadrant(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] MERGE SQL Statement for PG11
Date: 2018-03-22 18:42:04
Message-ID: CABOikdN+iC8Tf_0J3LiG0L5Y5Y1i+Y+6LMAxg8J2ohXMvP0EZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 22, 2018 at 1:36 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:

> On 21 March 2018 at 12:23, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
> wrote:
>
> > Fixed
>
> Looks like that this completes all outstanding items with the MERGE code.
>
>
A slightly improved version attached. Apart from doc cleanup based on
earlier feedback, fixed one assertion failure based on Rahila's report.
This was happening when target relation is referenced in the source
subquery. Fixed that and added a test case to test that situation.

Rebased on current master.

Thanks,
Pavan

--
Pavan Deolasee http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Attachment Content-Type Size
0002_merge_v23e_main.patch application/octet-stream 323.9 KB
0001_merge_v23e_onconflict_work.patch application/octet-stream 18.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2018-03-22 18:56:38 Re: Error detail/hint style fixup
Previous Message Pavel Stehule 2018-03-22 18:28:14 Re: Re: csv format for psql