Re: [HACKERS] MERGE SQL Statement for PG11

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: 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>, Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Stephen Frost <sfrost(at)snowman(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] MERGE SQL Statement for PG11
Date: 2018-01-23 13:51:25
Message-ID: CANP8+jJgS_KoN6DDteb_9-fUzfnp7Ytm9O5VE83dGpWp1pszkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 18 January 2018 at 17:19, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On 30 December 2017 at 11:01, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>
>> Attached: MERGE patch is now MOSTLY complete, but still WIP.

v11 attached

> LATEST SUMMARY
> Works
> * EXPLAIN
> * INSERT actions (thanks Pavan)
> * UPDATE actions (thanks Pavan)
> * DELETE actions
> * AND conditions (thanks Pavan)
> * Isolation tests and EvalPlanQual
> * DO NOTHING actions
> * PL/pgSQL
> * Triggers for row and statement
> * SQL Standard error requirements
>
> Not yet working
> * Partitioning
> * RLS
>
> Based on this successful progress I imagine I'll be looking to commit
> this by the end of the CF, allowing us 2 further months to bugfix.

This is complete and pretty clean now. 1200 lines of code, plus docs and tests.

I'm expecting to commit this and then come back for the Partitioning &
RLS later, but will wait a few days for comments and other reviews.

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
merge.v11.patch application/octet-stream 159.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2018-01-23 14:07:12 Re: GSoC 2018 Project Ideas & Mentors - Last Call
Previous Message Amit Kapila 2018-01-23 13:44:18 Re: pgsql: Allow UPDATE to move rows between partitions.