BUG #14452: Unexpected transaction behaviour
| От | rjsdg@sapo.pt |
|---|---|
| Тема | BUG #14452: Unexpected transaction behaviour |
| Дата | |
| Msg-id | 20161207024625.31175.32486@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #14452: Unexpected transaction behaviour
(John R Pierce <pierce@hogranch.com>)
|
| Список | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQ1MgpMb2dnZWQgYnk6ICAg ICAgICAgIFJvZHJpZ28gR2FyY2lhCkVtYWlsIGFkZHJlc3M6ICAgICAgcmpz ZGdAc2Fwby5wdApQb3N0Z3JlU1FMIHZlcnNpb246IDkuNi4xCk9wZXJhdGlu ZyBzeXN0ZW06ICAgV2luZG93cyA3IDY0Yml0CkRlc2NyaXB0aW9uOiAgICAg ICAgCgpIZWxsbywNCg0KSSBoYXZlIGEgT0xUUCBzeXN0ZW0gc3VwcG9ydGVk IGJ5IGEgSmF2YSBzdGFuZGFsb25lIGFwcCB1c2luZyBKREJDIDQyIERyaXZl cgpwb3N0Z3Jlc3FsLWpkYmMtOS40LTEyMTIgYW5kIGEgYmFja2VuZCBEQiBy dW5uaW5nIGluICJQb3N0Z3JlU1FMIDkuNi4xLApjb21waWxlZCBieSBWaXN1 YWwgQysrIGJ1aWxkIDE4MDAsIDY0LWJpdOKAnS4gVGhlIE9zIGlzIFdpbmRv d3MgNyA2NCBiaXQuDQoNClRoZSBzeXN0ZW0gbm9ybWFsIHRocm91Z2hwdXQg aXMgYWJvdXQgMTEwIHRyYW5zYWN0aW9ucy9taW4gY29uc3RhbnRseQp3aXRo b3V0IGRlZ3JhZGF0aW9uLiBSZWNlbnRseSBhIG5ldyBKYXZhIG1vZHVsZSBv ZiB0aGUgYXBwbGljYXRpb24gd2FzCmluc3RhbGxlZCBhbmQgd2hlbiB0aGUg YXBwIHN0YXJ0dXBzIHRoZSBzeXN0ZW0gdGhyb3VnaHB1dCBzdGFydHMgdG8g ZGVncmFkZQp0byB0aGUgcG9pbnQgdGhhdCByZWFjaGVzIDUwIHRyYW5zYWN0 aW9ucy9taW4sIGl04oCZcyBub3QgYW4gaW1tZWRpYXRlCmRvd25mYWxsIGlu IHRoZSB0aHJvdWdocHV0IGJ1dCBpdCBsb29zZXMgbGlrZSA1IHRvIDEwIHRy YW5zYWN0aW9ucyBwZXIKbWludXRlIHVudGlsIGl0IHJlYWNoZXMgNTAgdHJh bnNhY3Rpb25zIHBlciBtaW51dGUuIEF0IHRoaXMgcG9pbnQgaWYgd2UKdGVy bWluYXRlIHRoZSBvbmx5IGV4aXN0aW5nIGJhY2tlbmQgcGlkIG9mIHRoZSBu ZXcgSmF2YSBtb2R1bGUgKHRoYXQgaXMgaW4K4oCcaWRsZSBpbiB0cmFuc2Fj dGlvbuKAnSB3aXRoIGEgYmFja2VuZF94bWluIHZhbHVlKSBpbW1lZGlhdGx5 IGluIHRoZSBuZXh0Cm1pbnV0ZSB0aGUgdGhyb3VnaHB1dCByaXNlcyBhZ2Fp biB0byAxMTAgdHJhbnNhY3Rpb25zL21pbi4NCg0KV2XigJlyZSBub3QgYmVp bmcgYWJsZSB0byBpZGVudGlmeSB0aGUgcm9vdCBjYXVzZSBmb3IgdGhpcyBi ZWhhdmlvdXIsIGJ1dCB3ZQpmb3VuZCBvdXQgdGhhdCB0aGlzIG9jY3VycyBv bmx5IHdoZW4gd2UgdXNlIEpEQkMgRHJpdmVyIHZpYSBKYXZhIGFuZCBpcwpy ZXByb2R1Y2libGUgd2hlbmV2ZXIgd2UgdXNlIEpEQkMgZHJpdmVyIHdpdGgg YSBzbWFsbCBwaWVjZSBvZiBKYXZhIGNvZGUKKHNpbXVsYXRpbmcgdGhlIG5l dyBKYXZhIG1vZHVsZSkuIEF0IFBPSU5UIDQgYmVsb3cgd2Ugc3RheSB3aXRo IGEg4oCcaWRsZSBpbgp0cmFuc2FjdGlvbuKAnSBzZXNzaW9uIGFuZCBhIGJh Y2tlbmRfeG1pbiB2YWx1ZSBjb3JyZXNwb25kaW5nIHRvIHRoZSBzbmFwc2hv dApvZiB0aGUgbW9tZW50IHdoZW4gdGhlIOKAnHNlbGVjdCAqIGZyb20geOKA nSBxdWVyeSB3YXMgZmlyZWQuICBUaGlzIGRvZXNu4oCZdApoYXBwZW4gd2hl biB3ZSBjb25uZWN0IHZpYSBwc3FsIGFuZCByZXByb2R1Y2UgdGhlIHNpbWls YXIgYWN0aW9ucyB0aGUgaXNzdWUKaXMgbm90IG9jY3VyaW5nLCB0aGlzIGlz LCB3aXRoIHBzcWwgd2Ugc3RheSBhdCBQT0lOVCA0IHdpdGggYSDigJxpZGxl IGluCnRyYW5zYWN0aW9u4oCdIHNlc3Npb24gYnV0IHdpdGhvdXQgYSBiYWNr ZW5kX3htaW4gdmFsdWUuDQoNClJlYWRpbmcgUEcgZG9jdW1lbnRhdGlvbiB0 aGlzIGJlaGF2aW91ciBhcm91bmQgYmFja2VuZF94bWluIGRlcGVuZHMgb24g dGhlCnRyYW5zYWN0aW9uIGlzb2xhdGlvbiBsZXZlbCwgdGhlIHNuYXBzaG90 IGNvbGxlY3Rpb24gaXMgZGlmZXJlbnQuIFdlIHN1c3BlY3QKdGhhdCB0aGUg bG9zcyBvZiB0aHJvdWdocHV0IHJlc2lkZXMgaW4gdGhlIGZhY3QgdGhhdCB0 aGUg4oCcaWRsZSBpbgp0cmFuc2FjdGlvbuKAnSB3aXRoIGEgYmFja2VuZF94 bWluIGF2b2lkcyBvciBjYXVzZXMgZGVsYXlzIGluIHRoZSBNVkNDCnZlcnNp b25pbmcgY29yZSBzeXN0ZW0gb2YgUG9zdGdyZXMuIE5ldmVydGhlbGVzcyB3 ZSBkb27igJl0IHVuZGVyc3Rhbmcgd2h5IGl0CmhhcHBlbnMgb25seSB3aGVu IHVzaW5nIEpEQkMuDQoNClRoZSBuZXcgSmF2YSBtb2R1bGUgZG9lcyB0aGUg Zm9sbG93aW5nIGNvZGU6DQoNCkNsYXNzLmZvck5hbWUoIm9yZy5wb3N0Z3Jl c3FsLkRyaXZlciIpOw0KU3RyaW5nIHVybCA9ICJqZGJjOnBvc3RncmVzcWw6 Ly8xMjcuMC4wLjE6NTQzMy9wb3N0Z3JlcyI7DQpQcm9wZXJ0aWVzIHByb3Bz ID0gbmV3IFByb3BlcnRpZXMoKTsNCnByb3BzLnNldFByb3BlcnR5KCJ1c2Vy 4oCdLCJwb3N0Z3JlcyIpOw0KcHJvcHMuc2V0UHJvcGVydHkoInBhc3N3b3Jk 4oCdLOKAnSoqKioqKioqKioiKTsNCkNvbm5lY3Rpb24gY29ubiA9IERyaXZl ck1hbmFnZXIuZ2V0Q29ubmVjdGlvbih1cmwscHJvcHMpOw0KY29ubi5zZXRB dXRvQ29tbWl0KHRydWUpOw0KUHJlcGFyZWRTdGF0ZW1lbnQgc3QgPSBjb25u LnByZXBhcmVTdGF0ZW1lbnQoIkJFR0lOIik7DQpzdC5leGVjdXRlKCk7DQpz dCA9IGNvbm4ucHJlcGFyZVN0YXRlbWVudCgic2VsZWN0ICogZnJvbSB4Iik7 DQpzdC5leGVjdXRlKCk7DQovL1BPSU5UIDQgID0+IEF0IHRoaXMgcG9pbnQg cGdfc3RhdF9hY3Rpdml0eSBzaG93cyAiaWRsZSBpbiB0cmFuc2FjdGlvbuKA nSBhbmQKYSBiYWNrZW5kX3htaW4gdmFsdWUgZmlsbGVkDQpUaHJlYWQuc2xl ZXAoMzAwMDAwKTsNCmNvbm4uY2xvc2UoKTsNCg0KVGhlIHNhbWUgYWN0aW9u cyB2aWEgUFNRTCAoYWZ0ZXIgY29ubmVjdCkgYXJlOg0KDQogQkVHSU47DQog c2VsZWN0ICogZnJvbSB4Ow0KPT4gQXQgdGhpcyBwb2ludCBwZ19zdGF0X2Fj dGl2aXR5IHNob3dzICJpZGxlIGluIHRyYW5zYWN0aW9u4oCdIGFuZApiYWNr ZW5kX3htaW4gaXMgbnVsbA0KDQpXaHkgdGhlIGRpZmZlcmVudGUgYmVoYXZp b3VyPyBXZSB1bmRlcnN0YW5kIHRoYXQgUFNRTCBhbmQgSkRCQyB1c2UgZGlm ZmVyZW50CnByb3RvY29scyBidXQgaW4gdGVybXMgb2YgdHJhbnNhY3Rpb24g YmVoYXZpb3VyIHNob3VsZCBiZSB0aGUgc2FtZSwgdGhlIEphdmEKY29kZSBh bmQgUFNRTCBhcmUgZXF1aXZhbGVudCBpbiB0ZXJtcyBvZiB0cmFuc2FjdGlv biBiZWhhdmlvdXIuIENhbiBzb21lb25lCmhlbHA/Cgo=
В списке pgsql-bugs по дате отправления: