MERGE

Edit

Title

MERGE

Topic

SQL Commands

Created

2017-12-29 08:47:43

Last modified

2019-01-31 15:55:47 (5 years, 2 months ago)

Latest email

2019-01-31 15:54:58 (5 years, 2 months ago)

Status

2019-01: Returned with feedback

2018-11: Moved to next CF

2018-09: Moved to next CF

2018-07: Moved to next CF

2018-03: Moved to next CF

2018-01: Moved to next CF

Target version

Authors

Pavan Deolasee (pavan)

Reviewers

Become reviewer

Committer

Links

Emails

MERGE SQL Statement for PG11

First at 2017-10-27 08:55:05 by Simon Riggs <simon at 2ndquadrant.com>
Latest at 2018-06-25 16:54:35 by André Brière <brierand at outlook.com>
Latest attachment (0001-support-CTEs-with-MERGE.patch) at 2018-03-23 20:06:42 from Peter Geoghegan <pg at bowt.ie>

    Attachment (0001-support-CTEs-with-MERGE.patch) at 2018-03-23 20:06:42 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (0002_merge_v24_main.patch) at 2018-03-23 11:07:52 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (mt_mergeproj-delta.patch) at 2018-03-23 07:27:01 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (merge-onconflict-rebase-delta.patch) at 2018-03-23 04:30:47 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0002_merge_v23e_main.patch) at 2018-03-22 18:42:04 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (0002_merge_v23c_main.patch) at 2018-03-21 12:23:47 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge_v23b_onconflict_work.patch) at 2018-03-20 14:08:00 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge_v20.patch) at 2018-03-09 14:55:35 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge_v19b.patch) at 2018-03-08 12:54:25 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge_v18a.patch) at 2018-03-05 11:02:42 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge_v17a.patch) at 2018-02-27 17:53:06 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge-v16a-trap-planner.c.sql) at 2018-02-18 11:18:43 from Andreas Seltenreich <seltenreich at gmx.de> (Patch: No)
    Attachment (merge.sql) at 2018-02-16 01:07:08 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (merge_v16a.patch) at 2018-02-15 11:17:26 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge.v15a.patch) at 2018-02-07 09:24:45 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (TRAP-node-type-T_SubLink-prepunion.sql) at 2018-02-04 12:15:44 from Andreas Seltenreich <seltenreich at gmx.de> (Patch: No)
    Attachment (merge_indoubt_concurrent_output.v1.patch) at 2018-02-01 15:21:10 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (merge.v14.patch) at 2018-01-30 09:16:41 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (merge.v13.patch) at 2018-01-29 14:11:47 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (merge.v12.patch) at 2018-01-26 11:25:59 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (merge.v11.patch) at 2018-01-23 13:51:25 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (merge.v10a.patch) at 2018-01-18 17:19:44 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (sql-merge.html) at 2017-12-30 11:01:31 from Simon Riggs <simon at 2ndquadrant.com> (Patch: No)
    Attachment (sql-merge.html) at 2017-10-27 08:55:05 from Simon Riggs <simon at 2ndquadrant.com> (Patch: No)

Annotations

When	Who	Mail	Annotation
2018-03-11 04:34:06	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@bowt.ie> at 2018-03-11 03:57:08	Is the approach taken to support partitioning sound?

Re: [HACKERS] MERGE SQL Statement for PG11

First at 2018-03-22 23:13:16 by Peter Geoghegan <pg at bowt.ie>
Latest at 2018-04-06 11:52:19 by Pavan Deolasee <pavan.deolasee at gmail.com>
Latest attachment (ExecMergeMatched-thinko.patch) at 2018-04-06 07:38:43 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>

    Attachment (ExecMergeMatched-thinko.patch) at 2018-04-06 07:38:43 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (fnamespace.v1.patch) at 2018-04-05 15:58:46 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (merge_warn_v4.patch) at 2018-04-05 12:19:04 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (merge_warn_v3.patch) at 2018-04-05 11:56:47 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (merge_warn_v2.patch) at 2018-04-05 11:38:07 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (0001-Take-care-of-Andres-s-comments.patch) at 2018-04-05 06:01:48 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (merge_warn.patch) at 2018-04-04 12:46:15 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v27-0005-Fixes-per-review-comments.patch) at 2018-03-28 11:00:42 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (v26-0004-Basic-tab-completion-for-MERGE.patch) at 2018-03-27 09:28:36 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (v25-0002-Add-support-for-CTE.patch) at 2018-03-26 14:39:38 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)

MERGE SQL statement for PG12

First at 2018-06-19 11:06:44 by Pavan Deolasee <pavan.deolasee at gmail.com>
Latest at 2019-01-31 15:54:58 by Alvaro Herrera <alvherre at 2ndquadrant.com>
Latest attachment (0001-MERGE-SQL-Command-following-SQL-2016_v7.patch) at 2019-01-03 07:10:45 from Pavan Deolasee <pavan.deolasee at gmail.com>

    Attachment (0001-MERGE-SQL-Command-following-SQL-2016_v7.patch) at 2019-01-03 07:10:45 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)
    Attachment (0001-MERGE-SQL-Command-following-SQL-2016_v6.patch) at 2018-11-27 11:18:48 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)
    Attachment (0001-MERGE-SQL-Command-following-SQL-2016_v5.patch) at 2018-10-29 09:23:54 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)
    Attachment (0001-MERGE-SQL-Command-following-SQL-2016_v4.patch) at 2018-09-24 10:14:56 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)
    Attachment (0001-MERGE-SQL-Command-following-SQL-2016_v3.patch) at 2018-09-04 13:16:07 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)
    Attachment (crash.txt) at 2018-09-04 06:21:02 from Jaime Casanova <jaime.casanova at 2ndquadrant.com> (Patch: No)
    Attachment (0001-MERGE-SQL-Command-following-SQL-2016_v2.patch) at 2018-09-04 05:01:00 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)
    Attachment (0001-MERGE-SQL-Command-following-SQL-2016.patch) at 2018-06-19 11:06:44 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)

History

When	Who	What
2019-01-31 15:55:47	Álvaro Herrera (alvherre)	Closed in commitfest 2019-01 with status: Returned with feedback
2019-01-14 12:10:48	Simon Riggs (simon)	Changed authors to Pavan Deolasee (pavan)
2019-01-09 08:08:10	Mi Tar (mitar)	Posted comment with messageid <154702129079.11631.12119543228296180998.pgcf@coridan.postgresql.org>
2018-12-01 13:00:35	Dmitry Dolgov (erthalion)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-10-02 05:52:12	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Moved to next CF
2018-09-04 05:22:09	Pavan Deolasee (pavan)	Attached mail thread CABOikdNLhuxiF_aQxD-sXLhopmzW-o89Kq1=KcA4ynN-wL_0+Q@mail.gmail.com
2018-08-10 22:26:32	Andrew Dunstan (adunstan)	Closed in commitfest 2018-07 with status: Moved to next CF
2018-07-04 08:51:40	Peter Eisentraut (petere)	Changed reviewers to
2018-07-04 08:51:39	Peter Eisentraut (petere)	Changed committer to None
2018-06-25 16:54:35	André Brière (brierand)	Posted comment with messageid <152994567589.1367.7231982490649630078.pgcf@coridan.postgresql.org>
2018-06-19 19:33:07	Magnus Hagander (mha)	Detached mail thread CABOikdNLhuxiF_aQxD-sXLhopmzW-o89Kq1=KcA4ynN-wL_0+Q@mail.gmail.com
2018-06-19 11:19:52	Pavan Deolasee (pavan)	New status: Needs review
2018-06-19 11:13:23	Andrew Dunstan (adunstan)	Attached mail thread CABOikdNLhuxiF_aQxD-sXLhopmzW-o89Kq1=KcA4ynN-wL_0+Q@mail.gmail.com
2018-04-13 10:31:50	David Steele (dsteele)	New status: Waiting on Author
2018-04-13 10:31:24	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Moved to next CF
2018-04-13 10:31:17	David Steele (dsteele)	New status: Needs review
2018-04-13 10:31:02	David Steele (dsteele)	New status: Waiting on Author
2018-04-10 14:31:37	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Committed
2018-04-10 14:31:37	David Steele (dsteele)	Changed committer to simon
2018-04-03 15:08:59	Peter Eisentraut (petere)	New status: Ready for Committer
2018-03-27 03:18:58	Álvaro Herrera (alvherre)	Attached mail thread CAH2-WzkJdBuxj9PO=2QaO9-3h3xGbQPZ34kJH=HukRekwM-GZg@mail.gmail.com
2018-03-26 14:43:12	Pavan Deolasee (pavan)	New status: Needs review
2018-03-11 04:34:14	Peter Geoghegan (pgeoghegan)	New status: Waiting on Author
2018-03-11 04:34:07	Peter Geoghegan (pgeoghegan)	Added annotation "Is the approach taken to support partitioning sound?" to CAH2-Wz=ZwNQvp11XjeHo-dBLHr9GDRi1vao8w1j7LQ8mOsUkzw@mail.gmail.com
2018-03-06 22:56:59	Peter Geoghegan (pgeoghegan)	Added pgeoghegan as reviewer
2018-02-28 17:29:38	Pavan Deolasee (pavan)	Changed authors to Simon Riggs (simon), Pavan Deolasee (pavan)
2018-02-07 15:51:42	David Steele (dsteele)	Closed in commitfest 2018-01 with status: Moved to next CF
2018-02-01 15:26:28	Andreas Seltenreich (ansel)	Added ansel as reviewer
2018-01-30 09:19:45	Simon Riggs (simon)	New status: Needs review
2018-01-29 14:12:49	Simon Riggs (simon)	New status: Ready for Committer
2018-01-26 11:26:10	Simon Riggs (simon)	New status: Needs review
2018-01-25 13:30:20	Simon Riggs (simon)	New status: Waiting on Author
2018-01-23 13:52:03	Simon Riggs (simon)	New status: Ready for Committer
2018-01-06 15:07:07	Andrew Dunstan (adunstan)	Added adunstan as reviewer
2017-12-29 08:48:02	Simon Riggs (simon)	Changed authors to Simon Riggs (simon)
2017-12-29 08:47:43	Simon Riggs (simon)	Attached mail thread CANP8+jKitBSrB7oTgT9CY2i1ObfOt36z0XMraQc+Xrz8QB0nXA@mail.gmail.com
2017-12-29 08:47:43	Simon Riggs (simon)	Created patch record

Edit