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-04T12:46:15Z

Lists: pgsql-hackers

Attachments

merge_warn.patch (text/x-patch) patch

Hi Simon,

On 03/30/2018 07:10 AM, Simon Riggs wrote:
> No problems found, but moving proposed commit to 2 April pm
> 

There is a warning for this, 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