Re: BUG #13846: INSERT ON CONFLICT consumes sequencers onconflicts - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #13846: INSERT ON CONFLICT consumes sequencers onconflicts
Date
Msg-id CAM3SWZRQiijB6rRB0vwXyP2JskZ2itNhngFTKNXDYHXJ-Ao8XA@mail.gmail.com
Whole thread Raw
In response to BUG #13846: INSERT ON CONFLICT consumes sequencers on conflicts  (paul@salesintel.com)
Responses Re: BUG #13846: INSERT ON CONFLICT consumes sequencersonconflicts
Re: BUG #13846: INSERT ON CONFLICT consumes sequencersonconflicts
List pgsql-bugs
T24gV2VkLCBKYW4gNiwgMjAxNiBhdCAxOjAwIFBNLCBQYXVsIDxwYXVsQHNhbGVzaW50ZWwuY29t
PiB3cm90ZToNCj4gTXkgb25seSBwb2ludCBpcywgdGhlcmXigJlzIGFub3RoZXIgZ3JlYXQgY2Fw
YWJpbGl0eSBpbiBQb3N0Z3JlcywgZm9yIGRvaW5nDQo+IGVmZmljaWVudCBjb25jdXJyZW50IFVQ
U0VSVFMsIGJ1dCB0aGF0IG9uZSBvZiB0aGUgbW9zdCBjb21tb24gYW5kIHByaW1lIHVzZQ0KPiBj
YXNlcyBmb3IgaXQgaXMgZ29pbmcgdG8gY29zdCBtb3JlIG1vbmV5IGZyb20gaGF2aW5nIHRvIHVz
ZSA2NGJpdCBudW1iZXJzDQo+IGV2ZXJ5d2hlcmUgZm9yIG5vIGdvb2QgcmVhc29uLg0KDQpOb3Qg
cmVhbGx5OyBhdCBsZWFzdCwgaXQgd29uJ3QgaW5jcmVhc2UgdGhlIHNpemUgb2YgYSBwbGFpbiBC
SUdTRVJJQUwNCnByaW1hcnkga2V5IGluZGV4ICh3aGljaCB3aWxsIGdlbmVyYWxseSBub3QgYmUg
Y29tcG9zaXRlKToNCg0KcG9zdGdyZXM9IyBjcmVhdGUgdGFibGUgZm9vIGFzIHNlbGVjdCAocmFu
ZG9tKCkgKiAxMDAwMDAwMDApOjppbnQ0DQpwa2V5IGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsIDEw
MDAwMCk7DQpTRUxFQ1QgMTAwMDAwDQpwb3N0Z3Jlcz0jIGNyZWF0ZSBpbmRleCBvbiBmb28gKHBr
ZXkpOw0KQ1JFQVRFIElOREVYDQoNCnBvc3RncmVzPSMgXGR0KyBmb28NCiAgICAgICAgICAgICAg
ICAgICBMaXN0IG9mIHJlbGF0aW9ucw0KIFNjaGVtYSDilIIgTmFtZSDilIIgVHlwZSAg4pSCIE93
bmVyIOKUgiAgU2l6ZSAgIOKUgiBEZXNjcmlwdGlvbg0K4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA
4pS84pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA
4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA
4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSADQogcHVibGljIOKUgiBmb28gIOKUgiB0YWJsZSDi
lIIgcGcgICAg4pSCIDM1NDQga0Ig4pSCDQooMSByb3cpDQoNCnBvc3RncmVzPSMgXGRpKyBmb29f
cGtleV9pZHgNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIExpc3Qgb2YgcmVsYXRpb25zDQog
U2NoZW1hIOKUgiAgICAgTmFtZSAgICAg4pSCIFR5cGUgIOKUgiBPd25lciDilIIgVGFibGUg4pSC
ICBTaXplICAg4pSCIERlc2NyaXB0aW9uDQrilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDi
lIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDi
lIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilLzi
lIDilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilIDilIDi
lIDilIDilIDilIANCiBwdWJsaWMg4pSCIGZvb19wa2V5X2lkeCDilIIgaW5kZXgg4pSCIHBnICAg
IOKUgiBmb28gICDilIIgMjIwOCBrQiDilIINCigxIHJvdykNCg0KcG9zdGdyZXM9IyBhbHRlciB0
YWJsZSBmb28gYWx0ZXIgY29sdW1uIHBrZXkgdHlwZSBpbnQ4Ow0KQUxURVIgVEFCTEUNCg0KcG9z
dGdyZXM9IyBcZGkrIGZvb19wa2V5X2lkeA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgTGlz
dCBvZiByZWxhdGlvbnMNCiBTY2hlbWEg4pSCICAgICBOYW1lICAgICDilIIgVHlwZSAg4pSCIE93
bmVyIOKUgiBUYWJsZSDilIIgIFNpemUgICDilIIgRGVzY3JpcHRpb24NCuKUgOKUgOKUgOKUgOKU
gOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU
vOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKU
gOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKU
gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgA0KIHB1YmxpYyDilIIgZm9vX3BrZXlfaWR4IOKU
giBpbmRleCDilIIgcGcgICAg4pSCIGZvbyAgIOKUgiAyMjA4IGtCIOKUgg0KKDEgcm93KQ0KDQpU
aGUgdW5jaGFuZ2VkIHNpemUgb2YgdGhlIGluZGV4IGZvb19wa2V5X2lkeCBzZWVuIGhlcmUgZHVl
IHRvDQphbGlnbm1lbnQgY29uc2lkZXJhdGlvbnMuIEdyYW50ZWQsIHRoZSBoZWFwIG1pZ2h0IHN0
aWxsIGJlIGEgYml0DQpsYXJnZXIgdGhhbiBpdCB3b3VsZCBvdGhlcndpc2UgYmUsIGJlY2F1c2Ug
aXQgd2lsbCB1c3VhbGx5IGJlDQoiY29tcG9zaXRlIiwgYnV0IEkgdGhpbmsgdGhlICJjb3N0IiBv
ZiB5b3VyIHVzaW5nIGludDggd2lsbCBub3QgYnJlYWsNCnRoZSBiYW5rLg0KDQotLSANClBldGVy
IEdlb2doZWdhbg0K

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: BUG #13847: WARNING: skipping "pg_toast_" --- cannot vacuum indexes, views, or special system tables VACUUM
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #13594: pg_ctl.exe redirects stderr to Windows Events Log if stderr is redirected to pipe