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, 4 months ago) | ||||||||
Latest email | 2015-05-08 21:51:27 (9 years, 4 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:
|
||||||||
Emails |
|
When | Who | 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 |
When | Who | 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 |
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 |