INSERT ... ON CONFLICT {UPDATE | IGNORE}

Edit

ID 35

Title INSERT ... ON CONFLICT {UPDATE | IGNORE}

Topic SQL Commands

Created 2015-01-12 12:31:02

Last modified 2015-05-08 03:54:55 (9 years, 6 months ago)

Latest email 2015-05-08 21:51:27 (9 years, 6 months ago)

Status

2015-02: Committed

2014-12: Moved to next CF

Target version

Authors Peter Geoghegan (pgeoghegan)

Reviewers Svenne Krap (svennek)Become reviewer

Committer Andres Freund (andresfreund)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/35
git checkout commitfest/cf/35

Emails

INSERT ... ON CONFLICT UPDATE and logical decoding

First at 2015-02-19 00:35:14 by Peter Geoghegan <pg at heroku.com>
Latest at 2015-03-04 02:48:15 by Peter Geoghegan <pg at heroku.com>
Latest attachment (0004-Logical-decoding-support-for-ON-CONFLICT-UPDATE.patch) at 2015-03-04 02:48:15 from Peter Geoghegan <pg at heroku.com>

Attachment (0004-Logical-decoding-support-for-ON-CONFLICT-UPDATE.patch) at 2015-03-04 02:48:15 from Peter Geoghegan <pg at heroku.com> (Patch: Yes)
Attachment (0007-Logical-decoding-support-for-ON-CONFLICT-UPDATE.patch) at 2015-02-24 01:47:04 from Peter Geoghegan <pg at heroku.com> (Patch: Yes)

Annotations

When	Who	Mail	Annotation
2015-02-24 03:51:16	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-02-24 01:47:04	Rough patch prototyping an approach to logical decoding (consolidates WAL records from failed speculative insertions)

INSERT ... ON CONFLICT IGNORE (and UPDATE) 3.0

First at 2015-03-05 01:18:17 by Peter Geoghegan <pg at heroku.com>
Latest at 2015-04-25 02:21:37 by Peter Geoghegan <pg at heroku.com>
Latest attachment (invisible_bug.txt) at 2015-04-23 23:52:39 from Peter Geoghegan <pg at heroku.com>

    Attachment (invisible_bug.txt) at 2015-04-23 23:52:39 from Peter Geoghegan <pg at heroku.com> (Patch: No)
    Attachment (0002-Make-UPDATE-privileges-distinct-from-INSERT-privileg.patch.gz) at 2015-04-20 04:37:51 from Peter Geoghegan <pg at heroku.com> (Patch: No)
    Attachment (0002-Make-UPDATE-privileges-distinct-from-INSERT-privileg.patch.gz) at 2015-04-15 04:51:47 from Peter Geoghegan <pg at heroku.com> (Patch: No)
    Attachment (0002-Make-UPDATE-privileges-distinct-from-INSERT-privileg.patch.gz) at 2015-04-08 05:59:56 from Peter Geoghegan <pg at heroku.com> (Patch: No)
    Attachment (0001-Support-INSERT-.-ON-CONFLICT-IGNORE.patch) at 2015-03-26 18:00:20 from Peter Geoghegan <pg at heroku.com> (Patch: No)
    Attachment (misc-upsert-issues.patch) at 2015-03-17 19:11:58 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (test.sql) at 2015-03-16 15:10:26 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: No)
    Attachment (0001-Support-INSERT-.-ON-CONFLICT-IGNORE.patch) at 2015-03-05 01:18:17 from Peter Geoghegan <pg at heroku.com> (Patch: No)

Annotations

When	Who	Mail	Annotation
2015-03-05 01:19:42	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-03-05 01:18:17	Break out IGNORE support into dedicated commit, tweaks
2015-03-16 21:41:37	Dean Rasheed (deanr)	From Dean Rasheed <dean.a.rasheed@gmail.com> at 2015-03-16 15:10:26	Some RLS tests not working as expected
2015-03-26 18:13:55	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-03-26 18:00:20	V3.1 - new approach to storing/handling speculative insertion tokens, per discussion
2015-04-08 06:02:30	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-04-08 05:59:56	V3.2 - full inheritance support, new approach to WAL logging to suit logical decoding, multiple indexes can be inferred, collations and opclasses in inference clause
2015-04-15 08:34:05	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-04-15 04:51:47	V3.3 - New approach to logical decoding, refactoring of arbiter unique index inference, Arbiter indexes in non-text EXPLAIN output
2015-04-20 04:40:02	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-04-20 04:37:51	V3.4 - Newer minimal "affirmation" WAL record for speculative insertions, hybrid approach to logical decoding, new approach to RLS

INSERT ... ON CONFLICT UPDATE/IGNORE 4.0

First at 2015-04-27 01:02:06 by Peter Geoghegan <pg at heroku.com>
Latest at 2015-05-08 21:51:27 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (infer_arbiter_indexes_bugs.patch) at 2015-05-08 18:50:48 from Peter Geoghegan <pg at heroku.com>

Attachment (infer_arbiter_indexes_bugs.patch) at 2015-05-08 18:50:48 from Peter Geoghegan <pg at heroku.com> (Patch: Yes)

Annotations

When	Who	Mail	Annotation
2015-04-27 01:03:33	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-04-27 01:02:06	V4.0 of the patch - Github link
2015-05-05 05:54:06	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2015-05-05 05:53:06	Andres rebases - V5.0 branch on Github

History

When	Who	What
2015-05-08 03:54:55	Peter Geoghegan (pgeoghegan)	Closed in commitfest 2015-02 with status: Committed
2015-05-08 03:54:55	Peter Geoghegan (pgeoghegan)	Changed committer to andresfreund
2015-05-05 05:54:06	Peter Geoghegan (pgeoghegan)	Added annotation "Andres rebases - V5.0 branch on Github" to CAM3SWZRcD4v=1jjBmy+2xRAT0XKrU_w=SREVYkHKLLQZXL60jw@mail.gmail.com
2015-04-27 01:03:33	Peter Geoghegan (pgeoghegan)	Added annotation "V4.0 of the patch - Github link" to CAM3SWZTGE0z5_E8wRi9wt3qgOiMpSwtwr5uDcZDGhRZ1_pz6vg@mail.gmail.com
2015-04-27 01:02:53	Peter Geoghegan (pgeoghegan)	Attached mail thread CAM3SWZTGE0z5_E8wRi9wt3qgOiMpSwtwr5uDcZDGhRZ1_pz6vg@mail.gmail.com
2015-04-20 23:06:31	Peter Geoghegan (pgeoghegan)	Detached mail thread CAM3SWZQqgONFkkfcXOPwZvmeFbzJWdw+He1akRERmhd4_D0Wsg@mail.gmail.com
2015-04-20 23:06:27	Peter Geoghegan (pgeoghegan)	Detached mail thread CAM3SWZTEODEJLz82LK4eF2HYX+qEKrbc8-Vtq3_-aOf6kRSfiA@mail.gmail.com
2015-04-20 04:40:02	Peter Geoghegan (pgeoghegan)	Added annotation "V3.4 - Newer minimal "affirmation" WAL record for speculative insertions, hybrid approach to logical decoding, new approach to RLS" to CAM3SWZQN=bSgmiPkp=97=ajigVotTzxWXCucjhcZt+M5rpR5Mw@mail.gmail.com
2015-04-15 08:34:05	Peter Geoghegan (pgeoghegan)	Added annotation "V3.3 - New approach to logical decoding, refactoring of arbiter unique index inference, Arbiter indexes in non-text EXPLAIN output" to CAM3SWZQKzJXRBUybL7O6g96tJBignzgghNXC6b9DPNJt0q16GQ@mail.gmail.com
2015-04-08 06:02:30	Peter Geoghegan (pgeoghegan)	Added annotation "V3.2 - full inheritance support, new approach to WAL logging to suit logical decoding, multiple indexes can be inferred, collations and opclasses in inference clause" to CAM3SWZT1J6nFUad9t0XzAgyXBEz3qtuRSg=aPCGVDJ6qoK40_w@mail.gmail.com
2015-03-26 18:13:55	Peter Geoghegan (pgeoghegan)	Added annotation "V3.1 - new approach to storing/handling speculative insertion tokens, per discussion" to CAM3SWZT2PyPs-7EGovYZvprTBdm+N_0uKLzvve7D5BoAax3kYQ@mail.gmail.com
2015-03-16 21:41:37	Dean Rasheed (deanr)	Added annotation "Some RLS tests not working as expected" to CAEZATCWnQ6LaO6D_gaqrNC-BbydcY_aGT4GY-bMn-5XWKu9Kbg@mail.gmail.com
2015-03-16 10:42:02	Svenne Krap (svennek)	Added svennek as reviewer
2015-03-05 01:19:42	Peter Geoghegan (pgeoghegan)	Added annotation "Break out IGNORE support into dedicated commit, tweaks" to CAM3SWZS9DTFt1=sQT=WFdp5UFkOac2Qc1i5WE-Od4BXJZ=JsCw@mail.gmail.com
2015-03-05 01:19:10	Peter Geoghegan (pgeoghegan)	Attached mail thread CAM3SWZS9DTFt1=sQT=WFdp5UFkOac2Qc1i5WE-Od4BXJZ=JsCw@mail.gmail.com
2015-02-24 03:51:16	Peter Geoghegan (pgeoghegan)	Added annotation "Rough patch prototyping an approach to logical decoding (consolidates WAL records from failed speculative insertions)" to CAM3SWZSg3nLXPMj0bJ+JqkrNovaog3HnpA8Td-YzJVvz0442eA@mail.gmail.com
2015-02-24 03:48:57	Peter Geoghegan (pgeoghegan)	Attached mail thread CAM3SWZTD4MXS=RM+wZa9U9ZnLWu1OzhQWkFeY-gk=eBFxnHOvA@mail.gmail.com
2015-02-19 06:48:04	Peter Geoghegan (pgeoghegan)	Added annotation "Call to figure out behavior of inference of (hypothetical) unique indexes using opclasses that have "equality" operator not matching that of default opclass" to CAM3SWZR3wDOCtqx6KuUzr98+oVQB09dp1j5P9Zyz-8qm9od20w@mail.gmail.com
2015-02-18 21:45:19	Peter Geoghegan (pgeoghegan)	Added annotation "V2.3 - tqual.c overhaul, livelock insurance for exclusion constraints, miscellaneous polishing" to CAM3SWZTLuPnH+2nH18mEU0G8eg3DbKNNsmSMunTF-vD54zHV4Q@mail.gmail.com
2015-02-18 07:27:36	Peter Geoghegan (pgeoghegan)	Added annotation "V2.2 - Better parser representation, Cleaner ExecInsert() control flow, various points of style" to CAM3SWZTjpOXV4pjNWoSo5TLacDA-2OjYVuNTus8x0MAC_gwSpA@mail.gmail.com
2015-02-17 02:37:29	Peter Geoghegan (pgeoghegan)	Added annotation "Quick and dirty patches demonstrating tqual.c simplifications" to CAM3SWZQczLK-Y6+-y0Y_ePGEh2Mtt5B8OT=QyCt2RrSS==09gQ@mail.gmail.com
2015-02-16 02:31:11	Peter Geoghegan (pgeoghegan)	Added annotation "Short review" to 54DEBF82.8030402@BlueTreble.com
2015-02-16 02:30:55	Peter Geoghegan (pgeoghegan)	Added annotation "Heikki considers breaking out speculative insertion for benefit of ordinary exclusion constraint insertion" to 54DFC6F8.5050108@vmware.com
2015-02-13 08:08:05	Michael Paquier (michael-kun)	Closed in commitfest 2014-12 with status: Returned with Feedback
2015-01-23 21:54:51	Peter Geoghegan (pgeoghegan)	Attached mail thread CAM3SWZQqgONFkkfcXOPwZvmeFbzJWdw+He1akRERmhd4_D0Wsg@mail.gmail.com
2015-01-12 12:31:12	Michael Paquier (michael-kun)	Changed authors to Peter Geoghegan (pgeoghegan)
2015-01-12 12:31:02	Michael Paquier (michael-kun)	Attached mail thread CAM3SWZTEODEJLz82LK4eF2HYX+qEKrbc8-Vtq3_-aOf6kRSfiA@mail.gmail.com
2015-01-12 12:31:02	Michael Paquier (michael-kun)	Created patch record

Edit