BUG #14343: UPSERT (ON CONFLICT) doesn't check ON CONFLICT constraint first - Mailing list pgsql-bugs
| From | reyes.r.ponce@gmail.com |
|---|---|
| Subject | BUG #14343: UPSERT (ON CONFLICT) doesn't check ON CONFLICT constraint first |
| Date | |
| Msg-id | 20160927175223.20214.60920@wrigleys.postgresql.org Whole thread Raw |
| Responses |
Re: BUG #14343: UPSERT (ON CONFLICT) doesn't check ON CONFLICT constraint first
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM0MwpMb2dnZWQgYnk6ICAg ICAgICAgIFJleWVzIFBvbmNlCkVtYWlsIGFkZHJlc3M6ICAgICAgcmV5ZXMu ci5wb25jZUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMgpP cGVyYXRpbmcgc3lzdGVtOiAgIFJIRUwgNC44LjItMTYsIDY0LWJpdApEZXNj cmlwdGlvbjogICAgICAgIAoKLS0gQ3JlYXRlIGEgdGFibGUgd2l0aCBhIGtl eSwgb25lIG5vdCBudWxsIGNvbHVtbiwgYW5kIG9uZSBudWxsYWJsZQpjb2x1 bW4uDQoNCkNSRUFURSBUQUJMRSBwdWJsaWMuTXlUYWJsZQ0KKA0KCU1ZX0lE IGludGVnZXIgcHJpbWFyeSBrZXkgTk9UIE5VTEwsDQoJQ09MMSAgaW50ZWdl ciAgIE5PVCBOVUxMLA0KCUNPTDIgIGludGVnZXIsDQoJQ1JFVE5fVFMgICAg ICB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUgICBOT1QgTlVMTCwNCglDUkVU Tl9VU0VSX0lEIHZhcmNoYXIgICBOT1QgTlVMTCwNCglVUERUX1RTICAgICAg IHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSAgLA0KCVVQRFRfVVNFUl9JRCAg dmFyY2hhciAgDQopOw0KDQotLSBDcmVhdGUgYSBmdW5jdGlvbiB0byB1cHNl cnQgd2hhdGV2ZXIgaXMgcGFzc2VkIGluLiANCg0KQ1JFQVRFIE9SIFJFUExB Q0UgRlVOQ1RJT04gcHVibGljLnVwc2VydF9teXRhYmxlKA0KICAgIGlfbXlf aWQgaW50ZWdlciwNCiAgICBpX2NvbDF2YWwgaW50ZWdlciBERUZBVUxUIE5V TEw6OmludGVnZXIsDQogICAgaV9jb2wydmFsIGludGVnZXIgREVGQVVMVCBO VUxMOjppbnRlZ2VyDQogICAgKQ0KICBSRVRVUk5TIGpzb24gQVMNCiRCT0RZ JA0KREVDTEFSRSANCiAgICBnZXRfcm93cyBqc29uOw0KICAgIGJlZ2luU3Fs IHRleHQgOj0gDQogICAgJ0lOU0VSVCBJTlRPIHB1YmxpYy5NeVRhYmxlKA0K ICAgICAgICAgICAgTVlfSUQsIENPTDEsIENPTDIsIENSRVROX1RTLCBDUkVU Tl9VU0VSX0lELCBVUERUX1RTLApVUERUX1VTRVJfSUQpDQogICAgVkFMVUVT ICgkMSwgJDIsICQzLCBOT1coKSwgY3VycmVudF91c2VyLCBOT1coKSwgY3Vy cmVudF91c2VyKSANCiAgICBPTiBDT05GTElDVChNWV9JRCkgDQogICAgRE8g VVBEQVRFIFNFVCBVUERUX1RTID0gTk9XKCksIFVQRFRfVVNFUl9JRCA9IGN1 cnJlbnRfdXNlciwgJzsNCiAgICBjb21tYSB0ZXh0IDo9ICcnOw0KICAgIGVu ZFNxbCB0ZXh0IDo9ICcnOw0KICAgIHNxbCB0ZXh0IDo9ICcnOw0KQkVHSU4N Cg0KLS0gVmFsaWRhdGUgaW5wdXQgcGFyYW1ldGVycyAtIE1VU1QgU1BFQ0lG WSBQSw0KDQpJRiAoIGlfbXlfaWQgaXMgTlVMTCBPUiBpX215X2lkID0gJzAn KSBUSEVODQogICAgUmFpc2UgRXhjZXB0aW9uICdJTlZBTElEIElOUFVUOiBJ ZCBjYW5ub3QgYmUgbnVsbCcgdXNpbmcgZXJyY29kZSA9CiczJzsNCkVORCBJ RjsNCg0KLyogQ3JlYXRlIG1pZGRsZSBTUUwgKHRoZSBmaWVsZHMgdG8gdXBk YXRlKS4NCiANCiAgIEFmdGVyIHdlIHNlZSB0aGUgZmlyc3Qgbm9uLW51bGwg cGFyYW1ldGVyLCBzZXQgdGhlIGNvbW1hIHRvIGEgY29tbWEKaW5zdGVhZCBv ZiBibGFuay4uLiAgDQogICANCiAgIFRoZSAkIHZhcmlhYmxlcyBsaW5lIHVw IHdpdGggdGhlIG9yZGVyIGluIHRoZSAiRVhFQ1VURSBzcWwgVVNJTkciCnN0 YXRlbWVudCBiZWxvdywgbm90IGluIG9yZGVyIGluIHRoZSBwYXJhbWV0ZXIg bGlzdCBhYm92ZS4gICAgIA0KICAgKi8NCklGIChpX2NvbDF2YWwgaXMgbm90 IE5VTEwpIFRIRU4NCiAgICBlbmRTcWwgOj0gZW5kU3FsIHx8IGNvbW1hIHx8 ICdDT0wxID0gJDInOw0KICAgIGNvbW1hIDo9ICcsICc7ICAgICAgIA0KRU5E IElGOw0KDQpJRiAoaV9jb2wydmFsIGlzIG5vdCBOVUxMKSBUSEVODQogICAg ZW5kU3FsIDo9IGVuZFNxbCB8fCBjb21tYSB8fCAnQ09MMiA9ICQzJzsNCiAg ICBjb21tYSA6PSAnLCAnOyAgICAgICANCkVORCBJRjsNCg0KLS0gcmFpc2Ug Tk9USUNFICclJywgYmVnaW5TcWw7ICAvKiBERUJVR0dJTkcgQ09ERSAgLSBP dXRwdXRzIG1lc3NhZ2UgaW4KcGxBZG1pbiBtZXNzYWdlcyB0YWIuICovDQot LSByYWlzZSBOT1RJQ0UgJyUnLCBlbmRTcWw7ICAgIC8qIERFQlVHR0lORyBD T0RFICAtIE91dHB1dHMgbWVzc2FnZSBpbgpwbEFkbWluIG1lc3NhZ2VzIHRh Yi4gKi8NCg0Kc3FsIDo9IGJlZ2luU3FsIHx8IGVuZFNxbDsgDQoNCi0tIHJh aXNlIE5PVElDRSAnJScsIHNxbDsgIC8qIERFQlVHR0lORyBDT0RFIC0gT3V0 cHV0cyBtZXNzYWdlIGluIHBsQWRtaW4KbWVzc2FnZXMgdGFiLiAqLw0KDQov KiBUaGUgJCB2YXJpYWJsZXMgbGluZSB1cCB3aXRoIHRoZSBvcmRlciBpbiB0 aGUgVVNJTkcgY2xhdXNlIGJlbG93LCBub3QgaW4Kb3JkZXIgaW4gdGhlIHBh cmFtZXRlciBsaXN0LiAgKi8NCkVYRUNVVEUgc3FsDQogICBVU0lORyBpX215 X2lkLCBpX2NvbDF2YWwsIGlfY29sMnZhbDsgDQoNCi0tIFJldHVybiBqc29u Lg0KDQpzZWxlY3Qgcm93X3RvX2pzb24oZikgSU5UTyBnZXRfcm93cw0KICBm cm9tICgNCiAgICAgU0VMRUNUIE1ZX0lELCBDT0wxLCBDT0wyLCBjcmV0bl90 cywgY3JldG5fdXNlcl9pZCwgdXBkdF90cywKdXBkdF91c2VyX2lkDQogICAg IEZST00gcHVibGljLk15VGFibGUNCiAgICAgV0hFUkUgTVlfSUQgPSBpX215 X2lkKSBmOw0KDQpSRVRVUk4gZ2V0X3Jvd3M7DQoNCkVORA0KJEJPRFkkDQog IExBTkdVQUdFIHBscGdzcWwgVk9MQVRJTEUNCiAgQ09TVCAxMDA7DQoNCg0K LS0gQ2FsbCB0aGUgU1AgZm9yIGluaXRpYWwgaW5zZXJ0IChhbGwgY29sdW1u cykuIFdvcmtzIGZpbmUuDQpTRUxFQ1QgcHVibGljLnVwc2VydF9teXRhYmxl KA0KICAgIDEsDQogICAgMiwNCiAgICAzDQopOw0KDQoNCi0tIENhbGwgdGhl IFNQIGZvciB1cGRhdGUgb2YgdGhlIG51bGxhYmxlIGNvbHVtbi4gRXJyb3Ig YmVjYXVzZSBub3QgY2hlY2tpbmcKT04gQ09ORkxJQ1QgY29uZGl0aW9uIGZp cnN0Lg0KU0VMRUNUIHB1YmxpYy51cHNlcnRfbXl0YWJsZSgNCiAgICAxLA0K ICAgIE5VTEwsDQogICAgNQ0KKTsNCg0KDQovKg0KRVJST1I6ICBudWxsIHZh bHVlIGluIGNvbHVtbiAiY29sMSIgdmlvbGF0ZXMgbm90LW51bGwgY29uc3Ry YWludA0KREVUQUlMOiAgRmFpbGluZyByb3cgY29udGFpbnMgKDEsIG51bGws IDUsIDIwMTYtMDktMjcgMTc6MzI6NTEuMDU0ODk2KzAwLApwbF9tc3RyX3Vz ciwgMjAxNi0wOS0yNyAxNzozMjo1MS4wNTQ4OTYrMDAsIHBsX21zdHJfdXNy KS4NCkNPTlRFWFQ6ICBTUUwgc3RhdGVtZW50ICJJTlNFUlQgSU5UTyBwdWJs aWMuTXlUYWJsZSgNCiAgICAgICAgICAgIE1ZX0lELCBDT0wxLCBDT0wyLCBD UkVUTl9UUywgQ1JFVE5fVVNFUl9JRCwgVVBEVF9UUywKVVBEVF9VU0VSX0lE KQ0KICAgIFZBTFVFUyAoJDEsICQyLCAkMywgTk9XKCksIGN1cnJlbnRfdXNl ciwgTk9XKCksIGN1cnJlbnRfdXNlcikgDQogICAgT04gQ09ORkxJQ1QoTVlf SUQpIA0KICAgIERPIFVQREFURSBTRVQgVVBEVF9UUyA9IE5PVygpLCBVUERU X1VTRVJfSUQgPSBjdXJyZW50X3VzZXIsIENPTDIgPSAkMyINClBML3BnU1FM IGZ1bmN0aW9uIHVwc2VydF9teXRhYmxlKGludGVnZXIsaW50ZWdlcixpbnRl Z2VyKSBsaW5lIDQ2IGF0CkVYRUNVVEUNCg0KKioqKioqKioqKiBFcnJvciAq KioqKioqKioqDQoNCkVSUk9SOiBudWxsIHZhbHVlIGluIGNvbHVtbiAiY29s MSIgdmlvbGF0ZXMgbm90LW51bGwgY29uc3RyYWludA0KU1FMIHN0YXRlOiAy MzUwMg0KRGV0YWlsOiBGYWlsaW5nIHJvdyBjb250YWlucyAoMSwgbnVsbCwg NSwgMjAxNi0wOS0yNyAxNzozMjo1MS4wNTQ4OTYrMDAsCnBsX21zdHJfdXNy LCAyMDE2LTA5LTI3IDE3OjMyOjUxLjA1NDg5NiswMCwgcGxfbXN0cl91c3Ip Lg0KQ29udGV4dDogU1FMIHN0YXRlbWVudCAiSU5TRVJUIElOVE8gcHVibGlj Lk15VGFibGUoDQogICAgICAgICAgICBNWV9JRCwgQ09MMSwgQ09MMiwgQ1JF VE5fVFMsIENSRVROX1VTRVJfSUQsIFVQRFRfVFMsClVQRFRfVVNFUl9JRCkN CiAgICBWQUxVRVMgKCQxLCAkMiwgJDMsIE5PVygpLCBjdXJyZW50X3VzZXIs IE5PVygpLCBjdXJyZW50X3VzZXIpIA0KICAgIE9OIENPTkZMSUNUKE1ZX0lE KSANCiAgICBETyBVUERBVEUgU0VUIFVQRFRfVFMgPSBOT1coKSwgVVBEVF9V U0VSX0lEID0gY3VycmVudF91c2VyLCBDT0wyID0gJDMiDQpQTC9wZ1NRTCBm dW5jdGlvbiB1cHNlcnRfbXl0YWJsZShpbnRlZ2VyLGludGVnZXIsaW50ZWdl cikgbGluZSA0NiBhdApFWEVDVVRFDQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQoNCk9OIENPTkZMSUNUIHNob3VsZCBoYXZlIGJlZW4gY2hlY2tl ZCBiZWZvcmUgdGhlIGF0dGVtcHQgdG8gaW5zZXJ0IQ0KSWYgaSBpbXBsZW1l bnQgYXMgQ1RFIGluc3RlYWQgb2YgdXNpbmcgdGhlIG5ldyBzeW50YXggaXQg d29ya3MgZmluZS4NCk5vdCBjaGVja2luZyBPTiBDT05GTElDVCBjb25kaXRp b24gZmlyc3QgbWFrZXMgdGhlIG5ldyBzeW50YXggYXBwbGljYWJsZQp0bw0K ZmV3ZXIgc2NlbmFyaW9zIHRoYW4gaXQgc2hvdWxkIGJlIGFibGUgdG8gYmUg dXNlZCBmb3IuIEl0J3MgdXNlbGVzcyBmb3IgdGhpcwpwYXJ0aWN1bGFyIHVz ZSBjYXNlLi4uIA0KDQoqLw0KCgo=
pgsql-bugs by date: