INSERT ... ON CONFLICT {UPDATE | IGNORE}

Edit
Title INSERT ... ON CONFLICT {UPDATE | IGNORE}
Topic SQL Commands
Created 2015-01-12 12:31:02
Last modified 2015-05-08 03:54:55 (2 years, 7 months ago)
Latest email 2015-05-08 21:51:27 (2 years, 7 months ago)
Status
2015-02: Committed
2014-12: Moved to next CF
Authors Peter Geoghegan (pgeoghegan)
Reviewers Svenne Krap (svennek)Become reviewer
Committer Andres Freund (andresfreund)
Links
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