Re: BUG #13846: INSERT ON CONFLICT consumes sequencersonconflicts - Mailing list pgsql-bugs
| From | Paul |
|---|---|
| Subject | Re: BUG #13846: INSERT ON CONFLICT consumes sequencersonconflicts |
| Date | |
| Msg-id | 568d855c.c2e5ca0a.cb0fc.ffffe5c8@mx.google.com Whole thread Raw |
| In response to | Re: BUG #13846: INSERT ON CONFLICT consumes sequencers onconflicts (Peter Geoghegan <pg@heroku.com>) |
| List | pgsql-bugs |
QWxsIHRoaW5ncyBhcmUgcmVsYXRpdmUsIHRvIGhvdyBtdWNoIGRhdGEsIGFuZCBob3cgYmlnIHRo ZSBiYW5rLiBBbmQgaGF2aW5nIGJ1aWx0IGdpZ2FudGljIChiaWxsaW9ucyBvZiBiaWxsaW9ucyBv ZiBmYWN0IHJlY29yZHMsIGh1bmRyZWRzIG9mIGRpbWVuc2lvbnMsIG1pbGxpb25zIG9mIG1lbWJl cnMpIGRhdGEgd2FyZWhvdXNlIGFuZCBvbGFwIHNvbHV0aW9ucywgeW91IHJlYWxseSBkbyB0cnkg dG8ga2VlcCBzdHVmZiBzbWFsbCBiZWNhdXNlIGl0IGRvZXMgaGF2ZSBhbiBpbXBhY3Qgb24gY29z dCwgc2l6ZSwgYW5kIHBlcmZvcm1hbmNlLg0KIA0KT24gYSBtb3JlIGNvbmNlcHR1YWwgbm90ZSwg aWYgYSBzZXF1ZW5jZS1kZWZhdWx0ZWQgY29sdW1uIGlzIHVzZWQgdG8gcmVzb2x2ZSBhIGNvbmZs aWN0LCBpLmUuIGl04oCZcyBpbiB0aGUgY29uZmxpY3RfdGFyZ2V0LCB0aGFuIGJ5IGRlZmluaXRp b24gdGhlcmUgd2lsbCBuZXZlciBiZSBhIGNvbmZsaWN0IQ0KDQpTbyBhbnl0aGluZyBhYm91dCDi gJhmcmFnaWxpdHnigJkgYW5kIOKAmHBlZWstYWhlYWTigJkgYW5kIOKAmEJFRk9SRSB0cmlnZ2Vy c+KAmSBub3Qgd29ya2luZyBqdXN0IGRvZXNu4oCZdCBtYWtlIGFueSBzZW5zZS4gSWYgYSBzZXF1 ZW5jZSBpcyB1c2VkIHRvIHJlc29sdmUgYSBjb25mbGljdCwgdGhlcmUgd2lsbCBuZXZlciBiZSBh IGNvbmZsaWN0LCBhbmQgaWYgaXQgaXNu4oCZdCwgdGhlcmXigJlzIG5vIG5lZWQgdG8gZ2V0IHRo ZSBuZXh0IHNlcXVlbmNlZCB2YWx1ZSBiZWZvcmUgYmVpbmcgYWJsZSB0byBkZXRlcm1pbmUgY29u ZmxpY3RpbmcgcmVjb3JkcyBtZWFuaW5nIG5vIGNvbmN1cnJlbmN5IGlzc3VlczsgeW91IHdvdWxk IHN0aWxsIG9ubHkgbmVlZCB0byBnZXQgdGhlIG5leHQgc2VxdWVudGlhbCB2YWx1ZSBvbmx5IGZv ciBhbiBhY3R1YWwgaW5zZXJ0Lg0KDQoNCg0KDQpGcm9tOiBQZXRlciBHZW9naGVnYW4NClNlbnQ6 IFdlZG5lc2RheSwgSmFudWFyeSA2LCAyMDE2IDI6MTMgUE0NClRvOiBQYXVsDQpDYzogQW5kcmVz IEZyZXVuZDsgcGdzcWwtYnVncw0KU3ViamVjdDogUmU6IFtCVUdTXSBCVUcgIzEzODQ2OiBJTlNF UlQgT04gQ09ORkxJQ1QgY29uc3VtZXMgc2VxdWVuY2Vyc29uY29uZmxpY3RzDQoNCk9uIFdlZCwg SmFuIDYsIDIwMTYgYXQgMTowMCBQTSwgUGF1bCA8cGF1bEBzYWxlc2ludGVsLmNvbT4gd3JvdGU6 DQo+IE15IG9ubHkgcG9pbnQgaXMsIHRoZXJl4oCZcyBhbm90aGVyIGdyZWF0IGNhcGFiaWxpdHkg aW4gUG9zdGdyZXMsIGZvciBkb2luZw0KPiBlZmZpY2llbnQgY29uY3VycmVudCBVUFNFUlRTLCBi dXQgdGhhdCBvbmUgb2YgdGhlIG1vc3QgY29tbW9uIGFuZCBwcmltZSB1c2UNCj4gY2FzZXMgZm9y IGl0IGlzIGdvaW5nIHRvIGNvc3QgbW9yZSBtb25leSBmcm9tIGhhdmluZyB0byB1c2UgNjRiaXQg bnVtYmVycw0KPiBldmVyeXdoZXJlIGZvciBubyBnb29kIHJlYXNvbi4NCg0KTm90IHJlYWxseTsg YXQgbGVhc3QsIGl0IHdvbid0IGluY3JlYXNlIHRoZSBzaXplIG9mIGEgcGxhaW4gQklHU0VSSUFM DQpwcmltYXJ5IGtleSBpbmRleCAod2hpY2ggd2lsbCBnZW5lcmFsbHkgbm90IGJlIGNvbXBvc2l0 ZSk6DQoNCnBvc3RncmVzPSMgY3JlYXRlIHRhYmxlIGZvbyBhcyBzZWxlY3QgKHJhbmRvbSgpICog MTAwMDAwMDAwKTo6aW50NA0KcGtleSBmcm9tIGdlbmVyYXRlX3NlcmllcygxLCAxMDAwMDApOw0K U0VMRUNUIDEwMDAwMA0KcG9zdGdyZXM9IyBjcmVhdGUgaW5kZXggb24gZm9vIChwa2V5KTsNCkNS RUFURSBJTkRFWA0KDQpwb3N0Z3Jlcz0jIFxkdCsgZm9vDQogICAgICAgICAgICAgICAgICAgTGlz dCBvZiByZWxhdGlvbnMNCiBTY2hlbWEg4pSCIE5hbWUg4pSCIFR5cGUgIOKUgiBPd25lciDilIIg IFNpemUgICDilIIgRGVzY3JpcHRpb24NCuKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKU gOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgA0KIHB1YmxpYyDilIIgZm9vICDilIIgdGFibGUg4pSCIHBnICAg IOKUgiAzNTQ0IGtCIOKUgg0KKDEgcm93KQ0KDQpwb3N0Z3Jlcz0jIFxkaSsgZm9vX3BrZXlfaWR4 DQogICAgICAgICAgICAgICAgICAgICAgICAgICBMaXN0IG9mIHJlbGF0aW9ucw0KIFNjaGVtYSDi lIIgICAgIE5hbWUgICAgIOKUgiBUeXBlICDilIIgT3duZXIg4pSCIFRhYmxlIOKUgiAgU2l6ZSAg IOKUgiBEZXNjcmlwdGlvbg0K4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS8 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSADQogcHVibGljIOKUgiBmb29fcGtleV9pZHgg4pSCIGluZGV4IOKUgiBwZyAgICDilIIgZm9v ICAg4pSCIDIyMDgga0Ig4pSCDQooMSByb3cpDQoNCnBvc3RncmVzPSMgYWx0ZXIgdGFibGUgZm9v IGFsdGVyIGNvbHVtbiBwa2V5IHR5cGUgaW50ODsNCkFMVEVSIFRBQkxFDQoNCnBvc3RncmVzPSMg XGRpKyBmb29fcGtleV9pZHgNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIExpc3Qgb2YgcmVs YXRpb25zDQogU2NoZW1hIOKUgiAgICAgTmFtZSAgICAg4pSCIFR5cGUgIOKUgiBPd25lciDilIIg VGFibGUg4pSCICBTaXplICAg4pSCIERlc2NyaXB0aW9uDQrilIDilIDilIDilIDilIDilIDilIDi lIDilLzilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDi lIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDi lIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDi lIDilIDilIDilIDilIDilIDilIANCiBwdWJsaWMg4pSCIGZvb19wa2V5X2lkeCDilIIgaW5kZXgg 4pSCIHBnICAgIOKUgiBmb28gICDilIIgMjIwOCBrQiDilIINCigxIHJvdykNCg0KVGhlIHVuY2hh bmdlZCBzaXplIG9mIHRoZSBpbmRleCBmb29fcGtleV9pZHggc2VlbiBoZXJlIGR1ZSB0bw0KYWxp Z25tZW50IGNvbnNpZGVyYXRpb25zLiBHcmFudGVkLCB0aGUgaGVhcCBtaWdodCBzdGlsbCBiZSBh IGJpdA0KbGFyZ2VyIHRoYW4gaXQgd291bGQgb3RoZXJ3aXNlIGJlLCBiZWNhdXNlIGl0IHdpbGwg dXN1YWxseSBiZQ0KImNvbXBvc2l0ZSIsIGJ1dCBJIHRoaW5rIHRoZSAiY29zdCIgb2YgeW91ciB1 c2luZyBpbnQ4IHdpbGwgbm90IGJyZWFrDQp0aGUgYmFuay4NCg0KLS0gDQpQZXRlciBHZW9naGVn YW4NCg0K
pgsql-bugs by date: