Re: [HACKERS] MERGE SQL Statement for PG11

Jesper Pedersen <jesper.pedersen@redhat.com>

From: Jesper Pedersen <jesper.pedersen@redhat.com>

To: Simon Riggs <simon@2ndquadrant.com>

Cc: Pavan Deolasee <pavan.deolasee@gmail.com>, Peter Geoghegan <pg@bowt.ie>, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Robert Haas <robertmhaas@gmail.com>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Andrew Dunstan <andrew.dunstan@2ndquadrant.com>, Pavan Deolasee <pavan.deolasee@2ndquadrant.com>, Stephen Frost <sfrost@snowman.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2018-04-05T12:19:04Z

Lists: pgsql-hackers

Attachments

merge_warn_v4.patch (text/x-patch) patch v4

Hi,

On 04/05/2018 08:04 AM, Simon Riggs wrote:
> On 5 April 2018 at 12:56, Jesper Pedersen <jesper.pedersen@redhat.com> wrote:
>> Updated for non-assert build.
> 
> Thanks, pushed. Sorry to have you wait til v3
> 

That patch was a but rushed, and cut off too much.

As attached.

Best regards,
  Jesper

Commits

Add support for MERGE SQL command
- 7103ebb7aae8 15.0 landed
Avoid repeated name lookups during table and index DDL.
- 5f173040e324 9.4.0 cited
Use an MVCC snapshot, rather than SnapshotNow, for catalog scans.
- 568d4138c646 9.4.0 cited