Postgres Pro
Downloads
Home   >   mailing lists

BUG #14291: Sequence ID gets modified even for "on conflict" update - Mailing list pgsql-bugs

From mitramaddy@gmail.com
Subject BUG #14291: Sequence ID gets modified even for "on conflict" update
Date
Msg-id 20160820221708.1517.56191@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14291: Sequence ID gets modified even for "on conflict" update
List pgsql-bugs
Tree view 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI5MQpMb2dnZWQgYnk6ICAg
ICAgICAgIE1hZGR5IEpvbmVzCkVtYWlsIGFkZHJlc3M6ICAgICAgbWl0cmFt
YWRkeUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuNApPcGVy
YXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgMTAKRGVzY3JpcHRpb246ICAgICAg
ICAKCkhpLCBIZXJlIGFyZSB0aGUgc3RlcHMgdG8gcmVwbGljYXRlIHRoZSBi
dWc6DQoNClN0ZXAgMTogQ3JlYXRlIGEgc2ltcGxlIHRhYmxlDQpDUkVBVEUg
VEFCTEUgcHVibGljLnRlc3QNCigNCiAgdXNlcm5hbWUgdGV4dCBOT1QgTlVM
TCwNCiAgZnVsbG5hbWUgdGV4dCwNCiAgaWQgYmlnaW50IE5PVCBOVUxMIERF
RkFVTFQgbmV4dHZhbCgndGVzdF9pZF9zZXEnOjpyZWdjbGFzcyksDQogIENP
TlNUUkFJTlQgcHJpbWFyeV90ZXN0IFBSSU1BUlkgS0VZICh1c2VybmFtZSkN
CikNCg0KU3RlcCAyIC0gSGVyZSBpcyB0aGUgc2VxdWVuY2UgSUQ6DQoNCkNS
RUFURSBTRVFVRU5DRSBwdWJsaWMudGVzdF9pZF9zZXENCiAgSU5DUkVNRU5U
IDENCiAgTUlOVkFMVUUgMQ0KICBNQVhWQUxVRSA5MjIzMzcyMDM2ODU0Nzc1
ODA3DQogIFNUQVJUIDENCiAgQ0FDSEUgMTsNCg0KU3RlcCAzIC0gUnVuIHRo
ZSBmb2xsb3dpbmcgc2ltcGxlIFVQU0VSVCBTUUwgY29tbWFuZDoNCg0KSU5T
RVJUIElOVE8gdGVzdCAoVXNlcm5hbWUsRnVsbE5hbWUpIFZBTFVFUyAoJ2pv
aG4nLCdKb2huIEgnKSBPTgpDT05GTElDVChVc2VybmFtZSkgRE8gVXBkYXRl
IHNldCBGdWxsTmFtZT0nSm9obiBQJyB3aGVyZQp0ZXN0LlVzZXJuYW1lPSdq
b2huJzsNCg0KU3RlcCA0IC0gVGhpcyB3aWxsIGluY3JlYXNlIHRoZSAiU3Rh
cnQgYXQiIHZhbHVlIGluIHN0ZXAgMiBhYm92ZSBmb3IKdGVzdF9pZF9zZXEg
KHNpbmNlIHdlIGFyZSBkb2luZyBhIGJyYW5kIG5ldyBpbnNlcnQpLg0KDQpT
dGVwIDUgLSBOb3cgcnVuIHRoZSBFWEFDVCBzYW1lIFVQU0VSVCBjb21tYW5k
IGluIHN0ZXAgMyBmb3IgZml2ZSB0aW1lcyAob3IKbW9yZSkuIEluIHRhYmxl
IHRlc3QsIGl0IHdpbGwgY2hhbmdlIGZ1bGxuYW1lIHRvICJKb2huIFAiLg0K
DQpIb3dldmVyIHRoZXJlIGlzIGEgYnVnIGluIHRlc3RfaWRfc2VxIGJhY2tl
bmQNCg0KRXhwZWN0ZWQgcmVzdWx0OiBTaW5jZSB3ZSBhcmUgb25seSBkb2lu
ZyB1cGRhdGVzIGluIHN0ZXAgNSwgdGhlICJzdGFydCBhdCIKZm9yIHRlc3Rf
aWRfc2VxIHNob3VsZCByZW1haW4gYXQgMi4NCg0KQWN0dWFsIFJlc3VsdDog
RXZlbiB0aG91Z2ggdGhlcmUgYXJlIG5vIGluc2VydHMsIHRoZSAic3RhcnQg
YXQiIGZvcgp0ZXN0X2lkX3NlcSBpbmNyZWFzZXMgdG8gNi4NCg0KU3VtbWFy
eTogSXQgc2VlbXMgdGhhdCBQb3N0Z3Jlc3FsIGZpcnN0IHVwZGF0ZXMgdGVz
dF9pZF9zZXEgZXZlbiB0aG91Z2gKdGhlcmUgYXJlIG5vIGFjdHVhbCBpbnNl
cnRzIGhhcHBlbmluZy4gSXQgc2hvdWxkIG9ubHkgaW5jcmVtZW50IHRlc3Rf
aWRfc2VxCndoZW4gaXQgZG9lcyBhbiBhY3R1YWwgaW5zZXJ0Lg0KDQpJIGhh
dmUgYSBTUUwgVVBTRVJUIGNvbW1hbmQgd2hpY2ggcnVucyBhcm91bmQgMTAw
MCB0aW1lcy4gV2hhdCBpcyBoYXBwZW5pbmcKaXMgaWQgZm9yIGJyYW5kIG5l
dyBpbnNlcnQgaXMgMS4gVGhlbiBydW4gdGhlIHVwc2VydCBjb21tYW5kIDEw
MDAgdGltZXMuIE5vdwpkbyBhIGJyYW5kIG5ldyBpbnNlcnQuIFRoZSBpZCBm
b3IgdGhpcyBzaG91bGQgYmUgMi4gQnV0IGl0IGlzIGFjdHVhbGx5IDEwMDEu
ClRoaXMgaHVnZSBkaWZmZXJlbmNlIGluIGlkIGluIGp1c3QgdHdvIHJvd3Mg
c2VlbXMgb3V0IG9mIHBsYWNlLg0KDQpUZXN0ZWQgaW4gUG9zdGdyZXNxbCA5
LjUuNCBvbiBXaW5kb3dzIDEwLgoK

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Postgresql Performance Issue
Next
From: Tom Lane
Date:
Subject: Re: BUG #14291: Sequence ID gets modified even for "on conflict" update