Home > mailing lists
BUG #14191: plpgsql run infinit when i use bulk query first time - Mailing list pgsql-bugs

From	digoal@126.com
Subject	BUG #14191: plpgsql run infinit when i use bulk query first time
Date	June 15, 2016 08:48:17
Msg-id	20160615054752.5792.1646@wrigleys.postgresql.org Whole thread Raw
List	pgsql-bugs
Tree view
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE5MQpMb2dnZWQgYnk6ICAg
ICAgICAgIFpob3UgRGlnb2FsCkVtYWlsIGFkZHJlc3M6ICAgICAgZGlnb2Fs
QDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMwpPcGVyYXRpbmcg
c3lzdGVtOiAgIENlbnRPUyA3LnggeDY0CkRlc2NyaXB0aW9uOiAgICAgICAg
CgpjcmVhdGUgdGFibGUgdGVzdChpZCBpbnQsIGluZm8gdGV4dCk7DQoNCkNS
RUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHB1YmxpYy5mX2J1bGtfaW5zZXJ0
MShpX2sgaW50ZWdlcltdLCBpX3YKdGV4dFtdKQ0KIFJFVFVSTlMgdm9pZA0K
IExBTkdVQUdFIHBscGdzcWwNCiBTVFJJQ1QNCkFTICRmdW5jdGlvbiQNCmRl
Y2xhcmUgDQogIGlfbGVuZ3RoIGludCA6PSBhcnJheV9sZW5ndGgoaV9rLDEp
Ow0KICBzIHRpbWVzdGFtcDsNCiAgZSB0aW1lc3RhbXA7DQpiZWdpbiANCiAg
cyA6PSBjbG9ja190aW1lc3RhbXAoKTsgDQogIHJhaXNlIG5vdGljZSAnc3Rh
cnQ6ICUnLCBzOw0KICBpbnNlcnQgaW50byB0ZXN0IHNlbGVjdCBpX2tbaV0s
IGlfdltpXSBmcm9tIGdlbmVyYXRlX3NlcmllcygxLCBpX2xlbmd0aCkKdChp
KTsgDQogIGUgOj0gY2xvY2tfdGltZXN0YW1wKCk7IA0KICByYWlzZSBub3Rp
Y2UgJ2VuZDogJSwgJScsIGUsIGUtczsgDQplbmQ7DQokZnVuY3Rpb24kOw0K
DQp0aGUgZmlyc3QgY2FsbCBmb3IgbWFueSB0dXBsZXMgd2lsbCBydW4gZm9y
ZXZlcjogIA0Kc2VsZWN0IGZfYnVsa19pbnNlcnQxKGssdikgZnJvbSAoDQog
IHNlbGVjdCBhcnJheV9hZ2coaykgYXMgaywgYXJyYXlfYWdnKHYpIGFzIHYg
ZnJvbSAoDQogICAgc2VsZWN0IGssIG1kNShyYW5kb20oKTo6dGV4dCkgdiBm
cm9tIGdlbmVyYXRlX3NlcmllcygxLDEwMDAwMDApIHQoaykNCiAgKSB0DQop
IHQ7DQpOT1RJQ0U6ICBzdGFydDogMjAxNi0wNi0xNSAxMzo0NzowOS44Mzgw
OTMNCi4uLi4uICBhbmQgdGhlbiBydW4gZm9yZXZlciAuLi4uDQpwZXJmIHRv
cCBpczoNCk92ZXJoZWFkICBTaGFyZWQgT2JqZWN0ICAgICAgICBTeW1ib2wg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgCiAgICAgIA0KICAxNi45MCUgIFt1bmtub3duXSAgICAg
ICAgICAgIFsuXSAweDAwMDAwMDAwMDA2YWFjYjQgICAgICAgICAgICAgICAg
ICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgDQogICA1LjU4JSAg
W3Vua25vd25dICAgICAgICAgICAgWy5dIDB4MDAwMDAwMDAwMDZhYWNiOCAg
ICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAg
ICANCiAgIDUuNTElICBbdW5rbm93bl0gICAgICAgICAgICBbLl0gMHgwMDAw
MDAwMDAwNmFhY2IwICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgCiAgICAgIA0KICAgNS4zMiUgIFt1bmtub3duXSAgICAgICAg
ICAgIFsuXSAweDAwMDAwMDAwMDA2YWFjNDAgICAgICAgICAgICAgICAgICAg
ICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgDQogICAzLjcyJSAgW3Vu
a25vd25dICAgICAgICAgICAgWy5dIDB4MDAwMDAwMDAwMDZhYWMyYiAgICAg
ICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAN
CiAgIDMuNjglICBbdW5rbm93bl0gICAgICAgICAgICBbLl0gMHgwMDAwMDAw
MDAwNmFhZDJhICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgCiAgICAgIA0KICAgMy42MyUgIFt1bmtub3duXSAgICAgICAgICAg
IFsuXSAweDAwMDAwMDAwMDA2YWFjYzQgICAgICAgICAgICAgICAgICAgICAg
IAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAKICAgICAgDQogICAzLjYzJSAgW3Vua25v
d25dICAgICAgICAgICAgWy5dIDB4MDAwMDAwMDAwMDZhYWMyNyAgICAgICAg
ICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICANCiAg
IDIuOTAlICBba2VybmVsXSAgICAgICAgICAgICBba10gY2xlYXJfcGFnZV9j
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgCiAgICAgIA0KICAgMS43NiUgIFt1bmtub3duXSAgICAgICAgICAgIFsu
XSAweDAwMDAwMDAwMDA2YWFjYzEgICAgICAgICAgICAgICAgICAgICAgIAog
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAKICAgICAgDQogICAxLjYyJSAgW3Vua25vd25d
ICAgICAgICAgICAgWy5dIDB4MDAwMDAwMDAwMDZhYWMwOCAgICAgICAgICAg
ICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAK
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICANCiAgIDEu
NTQlICBbdW5rbm93bl0gICAgICAgICAgICBbLl0gMHgwMDAwMDAwMDAwNmFh
YzFkICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
CiAgICAgIA0KICAgMS41MCUgIFt1bmtub3duXSAgICAgICAgICAgIFsuXSAw
eDAwMDAwMDAwMDA2YWFkMjQgICAgICAgICAgICAgICAgICAgICAgIAogICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAKICAgICAgDQogICAwLjY0JSAgW2tlcm5lbF0gICAg
ICAgICAgICAgW2tdIGNvcHlfdXNlcl9nZW5lcmljX3N0cmluZyAgICAgICAg
ICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICANCiAgIDAuNDMl
ICBbdW5rbm93bl0gICAgICAgICAgICBbLl0gMHgwMDAwN2YyZmQ3NzE1OWUx
ICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAg
ICAgIA0KICAgMC40MSUgIFt1bmtub3duXSAgICAgICAgICAgIFsuXSAweDAw
MDA3ZjJmZDc3MTU2ZTggICAgICAgICAgICAgICAgICAgICAgIAogICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAKICAgICAgDQogICAwLjQwJSAgW3Vua25vd25dICAgICAg
ICAgICAgWy5dIDB4MDAwMDAwMDAwMDc5ZTllNyAgICAgICAgICANCg0KYnV0
IHdoZW4gaSBydW4gZmV3IHR1cGxlcyA1IHRpbWVzIGZpcnN0LCB0aGVuIHJ1
biBtYW55IG1vcmUgdHVwbGVzICwgaXQncwpvay4gDQpzZWxlY3QgZl9idWxr
X2luc2VydDEoayx2KSBmcm9tICgNCiAgc2VsZWN0IGFycmF5X2FnZyhrKSBh
cyBrLCBhcnJheV9hZ2codikgYXMgdiBmcm9tICgNCiAgICBzZWxlY3Qgaywg
bWQ1KHJhbmRvbSgpOjp0ZXh0KSB2IGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEs
MTAwKSB0KGspDQogICkgdA0KKSB0Ow0KLS0gY2FsbCA1IHRpbWVzLg0KYW5k
IHRoZW4gY2FsbA0Kc2VsZWN0IGZfYnVsa19pbnNlcnQxKGssdikgZnJvbSAo
DQogIHNlbGVjdCBhcnJheV9hZ2coaykgYXMgaywgYXJyYXlfYWdnKHYpIGFz
IHYgZnJvbSAoDQogICAgc2VsZWN0IGssIG1kNShyYW5kb20oKTo6dGV4dCkg
diBmcm9tIGdlbmVyYXRlX3NlcmllcygxLDEwMDAwMDAwKSB0KGspDQogICkg
dA0KKSB0Ow0KaXQncyBvayBub3cuDQpwb3N0Z3Jlcz0jIHNlbGVjdCBmX2J1
bGtfaW5zZXJ0MShrLHYpIGZyb20gKA0KICBzZWxlY3QgYXJyYXlfYWdnKGsp
IGFzIGssIGFycmF5X2FnZyh2KSBhcyB2IGZyb20gKA0KICAgIHNlbGVjdCBr
LCBtZDUocmFuZG9tKCk6OnRleHQpIHYgZnJvbSBnZW5lcmF0ZV9zZXJpZXMo
MSwxMDAwMDAwMCkgdChrKQ0KICApIHQNCikgdDsNCk5PVElDRTogIHN0YXJ0
OiAyMDE2LTA2LTE1IDEzOjQ2OjE4LjIxMjU2Mg0KTk9USUNFOiAgZW5kOiAy
MDE2LTA2LTE1IDEzOjQ2OjI3Ljc0NzQsIDAwOjAwOjA5LjUzNDgzOA0KIGZf
YnVsa19pbnNlcnQxIA0KLS0tLS0tLS0tLS0tLS0tLQ0KIA0KKDEgcm93KQ0K
DQoNCgoK
pgsql-bugs by date:
From: "cheddici@libero.it"
Date: 15 June 2016, 07:42:33
Subject:
From: Michael Paquier
Date: 15 June 2016, 10:37:16
Subject: Re: BUG #13907: Restore materialized view throw permission denied
BUG #14191: plpgsql run infinit when i use bulk query first time - Mailing list pgsql-bugs

Previous

Next
