Horton

Re: [HACKERS] MERGE SQL Statement for PG11

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Teodor Sigaev <teodor@sigaev.ru>, Pavan Deolasee <pavan.deolasee@gmail.com>, Jesper Pedersen <jesper.pedersen@redhat.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>, 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-05T16:07:11Z
Lists: pgsql-hackers 
Simon Riggs wrote:
> On 5 April 2018 at 16:09, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> > Quick item: parse_clause.h fails cpluspluscheck because it has a C++
> > keyword as a function argument name:
> >
> > ./src/include/parser/parse_clause.h:26:14: error: expected ‘,’ or ‘...’ before ‘namespace’
> >        List **namespace);
> >               ^~~~~~~~~
> 
> How's this as a fix?

WFM

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Add support for MERGE SQL command

  2. Avoid repeated name lookups during table and index DDL.

  3. Use an MVCC snapshot, rather than SnapshotNow, for catalog scans.