BUG #14368: Strange behaviour of set_config() in case of transaction failure

Поиск
Список
Период
Сортировка
От alena.zubets@gmail.com
Тема BUG #14368: Strange behaviour of set_config() in case of transaction failure
Дата
Msg-id 20161012151501.1413.41489@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM2OApMb2dnZWQgYnk6ICAg
ICAgICAgIEFsZW5hIFp1YmV0cwpFbWFpbCBhZGRyZXNzOiAgICAgIGFsZW5h
Lnp1YmV0c0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjQuNQpP
cGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSA0LjguMgpEZXNjcmlwdGlvbjog
ICAgICAgIAoKRG9jdW1lbnRhdGlvbiAoaHR0cHM6Ly93d3cucG9zdGdyZXNx
bC5vcmcvZG9jcy85LjQvc3RhdGljL3NxbC1zZXQuaHRtbCkKc3RhdGVzIGZv
bGxvd2luZyBhYm91dCBTRVQgY29tbWFuZDoNCjEpICJJZiBTRVQgKG9yIGVx
dWl2YWxlbnRseSBTRVQgU0VTU0lPTikgaXMgaXNzdWVkIHdpdGhpbiBhIHRy
YW5zYWN0aW9uIHRoYXQKaXMgbGF0ZXIgYWJvcnRlZCwgdGhlIGVmZmVjdHMg
b2YgdGhlIFNFVCBjb21tYW5kIGRpc2FwcGVhciB3aGVuIHRoZQp0cmFuc2Fj
dGlvbiBpcyByb2xsZWQgYmFjay4iIA0KMikgIlRoZSBmdW5jdGlvbiBzZXRf
Y29uZmlnIHByb3ZpZGVzIGVxdWl2YWxlbnQgZnVuY3Rpb25hbGl0eTsiDQoN
CnBzcWwgKDkuNC4wLCBzZXJ2ZXIgOS40LjUpDQpXQVJOSU5HOiBDb25zb2xl
IGNvZGUgcGFnZSAoODUyKSBkaWZmZXJzIGZyb20gV2luZG93cyBjb2RlIHBh
Z2UgKDEyNTApDQogICAgICAgICA4LWJpdCBjaGFyYWN0ZXJzIG1pZ2h0IG5v
dCB3b3JrIGNvcnJlY3RseS4gU2VlIHBzcWwgcmVmZXJlbmNlDQogICAgICAg
ICBwYWdlICJOb3RlcyBmb3IgV2luZG93cyB1c2VycyIgZm9yIGRldGFpbHMu
DQpTU0wgY29ubmVjdGlvbiAocHJvdG9jb2w6IFRMU3YxLjIsIGNpcGhlcjog
RUNESEUtUlNBLUFFUzI1Ni1HQ00tU0hBMzg0LApiaXRzOiAyNTYsIGNvbXBy
ZXNzaW9uOiBvZmYpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KZGJfbmFt
ZT0+IFxzZXQgVkVSQk9TSVRZIHZlcmJvc2UNCmRiX25hbWU9PiBTRUxFQ1Qg
cXVvdGVfbGl0ZXJhbChjdXJyZW50X3NldHRpbmcoJ2NvbmYucGFyYW0nKSk7
DQpFUlJPUjogIDQyNzA0OiB1bnJlY29nbml6ZWQgY29uZmlndXJhdGlvbiBw
YXJhbWV0ZXIgImNvbmYucGFyYW0iDQpMT0NBVElPTjogIEdldENvbmZpZ09w
dGlvbkJ5TmFtZSwgZ3VjLmM6NzU4Nw0KZGJfbmFtZT0+IERPDQpkYl9uYW1l
LT4gJCQNCmRiX25hbWUkPiBCRUdJTg0KZGJfbmFtZSQ+ICAgUEVSRk9STSBz
ZXRfY29uZmlnKCdjb25mLnBhcmFtJywgJ3ZhbHVlJywgRkFMU0UpOw0KZGJf
bmFtZSQ+DQpkYl9uYW1lJD4gICBSQUlTRSBOT1RJQ0UgJ2NvbmYucGFyYW0g
PSAlJywgY3VycmVudF9zZXR0aW5nKCdjb25mLnBhcmFtJyk7DQpkYl9uYW1l
JD4NCmRiX25hbWUkPiAgIFJBSVNFIEVYQ0VQVElPTiAnRVJST1InOw0KZGJf
bmFtZSQ+DQpkYl9uYW1lJD4gRU5EDQpkYl9uYW1lJD4gJCQ7DQpOT1RJQ0U6
ICAwMDAwMDogY29uZi5wYXJhbSA9IHZhbHVlDQpMT0NBVElPTjogIGV4ZWNf
c3RtdF9yYWlzZSwgcGxfZXhlYy5jOjMwNjgNCkVSUk9SOiAgUDAwMDE6IEVS
Uk9SDQpMT0NBVElPTjogIGV4ZWNfc3RtdF9yYWlzZSwgcGxfZXhlYy5jOjMw
NjgNCmRiX25hbWU9PiBTRUxFQ1QgcXVvdGVfbGl0ZXJhbChjdXJyZW50X3Nl
dHRpbmcoJ2NvbmYucGFyYW0nKSk7DQogcXVvdGVfbGl0ZXJhbA0KLS0tLS0t
LS0tLS0tLS0tDQogJycNCigxIHJvdykNCg0KDQpkYl9uYW1lPT4gU0VMRUNU
IHNldF9jb25maWcoJ2NvbmYucGFyYW0nLCAndmFsdWUnLCBGQUxTRSk7DQog
c2V0X2NvbmZpZw0KLS0tLS0tLS0tLS0tDQogdmFsdWUNCigxIHJvdykNCg0K
DQpkYl9uYW1lPT4gRE8NCmRiX25hbWUtPiAkJA0KZGJfbmFtZSQ+IEJFR0lO
DQpkYl9uYW1lJD4gICBQRVJGT1JNIHNldF9jb25maWcoJ2NvbmYucGFyYW0n
LCAnYW5vdGhlcl92YWx1ZScsIEZBTFNFKTsNCmRiX25hbWUkPg0KZGJfbmFt
ZSQ+ICAgUkFJU0UgTk9USUNFICdjb25mLnBhcmFtID0gJScsIGN1cnJlbnRf
c2V0dGluZygnY29uZi5wYXJhbScpOw0KZGJfbmFtZSQ+DQpkYl9uYW1lJD4g
ICBSQUlTRSBFWENFUFRJT04gJ0VSUk9SJzsNCmRiX25hbWUkPg0KZGJfbmFt
ZSQ+IEVORA0KZGJfbmFtZSQ+ICQkOw0KTk9USUNFOiAgMDAwMDA6IGNvbmYu
cGFyYW0gPSBhbm90aGVyX3ZhbHVlDQpMT0NBVElPTjogIGV4ZWNfc3RtdF9y
YWlzZSwgcGxfZXhlYy5jOjMwNjgNCkVSUk9SOiAgUDAwMDE6IEVSUk9SDQpM
T0NBVElPTjogIGV4ZWNfc3RtdF9yYWlzZSwgcGxfZXhlYy5jOjMwNjgNCmRi
X25hbWU9PiBTRUxFQ1QgcXVvdGVfbGl0ZXJhbChjdXJyZW50X3NldHRpbmco
J2NvbmYucGFyYW0nKSk7DQogcXVvdGVfbGl0ZXJhbA0KLS0tLS0tLS0tLS0t
LS0tDQogJ3ZhbHVlJw0KKDEgcm93KQ0KDQpQcm9ibGVtLCB0aGF0IEkgc2Vl
IGhlcmUgaXMgdGhhdCB0aGUgcmVzdWx0IG9mIHNldF9jb25maWcoKSBpcyBu
b3QgYmVpbmcKZnVsbHkgcm9sbGVkIGJhY2sgd2hlbjoNCjEpIGNvcnJlc3Bv
bmRpbmcgY29uZmlndXJhdGlvbiBwYXJhbWV0ZXIgd2FzIG5vdCBzZXQgeWV0
DQoyKSB0cmFuc2FjdGlvbiwgd2l0aGluIHdoaWNoIHNldF9jb25maWcoKSBp
cyBiZWluZyBjYWxsZWQgZmFpbHMKCg==

В списке pgsql-bugs по дате отправления:

Предыдущее
От: jan.kort@genetics.nl
Дата:
Сообщение: BUG #14367: Pressing execute 20-30 times really fast causes loop of error messages
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #14344: string_agg(DISTINCT ..) crash