BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension - Mailing list pgsql-bugs

From daniele.varrazzo@gmail.com
Subject BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension
Date
Msg-id 20161208191642.1407.30751@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension
Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension
List pgsql-bugs
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQ1NgpMb2dnZWQgYnk6ICAg
ICAgICAgIERhbmllbGUgVmFycmF6em8KRW1haWwgYWRkcmVzczogICAgICBk
YW5pZWxlLnZhcnJhenpvQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246
IDkuNS40Ck9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246
ICAgICAgICAKCkFzIHBlciB0aXRsZS4gVG8gdGVzdDoNCg0KMSkgY3JlYXRl
IGFuIGV4dGVuc2lvbiBjb250YWluaW5nIGEgdGFibGUsIGUuZy46DQoNCiQg
Y2F0IC91c3Ivc2hhcmUvcG9zdGdyZXNxbC85LjUvZXh0ZW5zaW9uL3Rlc3Rl
eHQuY29udHJvbCANCmRlZmF1bHRfdmVyc2lvbiA9ICcxLjAnDQpjb21tZW50
ID0gJ3Rlc3Qgb2YgYSBwZyBidWcnDQpzdXBlcnVzZXIgPSBmYWxzZQ0KDQok
IGNhdCAvdXNyL3NoYXJlL3Bvc3RncmVzcWwvOS41L2V4dGVuc2lvbi90ZXN0
ZXh0LS0xLjAuc3FsIA0KY3JlYXRlIHRhYmxlIHRlc3R0YmwgKGlkIHNlcmlh
bCBwcmltYXJ5IGtleSwgZGF0YSB0ZXh0KTsNCnNlbGVjdCBwZ19jYXRhbG9n
LnBnX2V4dGVuc2lvbl9jb25maWdfZHVtcCgndGVzdHRibCcsICcnKTsNCg0K
DQoyKSBMb2FkIHRoZSBleHRlbnNpb24gaW4gdGhlIGRhdGFiYXNlDQoNCj0j
IGNyZWF0ZSBkYXRhYmFzZSB0ZXN0Ow0KQ1JFQVRFIERBVEFCQVNFDQoNCj0j
IFxjIHRlc3Q7DQp0ZXN0PSMgY3JlYXRlIHNjaGVtYSBleHRzY2hlbWE7DQpD
UkVBVEUgU0NIRU1BDQoNCnRlc3Q9IyBjcmVhdGUgZXh0ZW5zaW9uIHRlc3Rl
eHQgd2l0aCBzY2hlbWEgZXh0c2NoZW1hOw0KQ1JFQVRFIEVYVEVOU0lPTg0K
DQoNCjMpIEN1c3RvbWl6ZSBleHRlbnNpb24gdGFibGUgcGVybWlzc2lvbnMN
Cg0KdGVzdD0jIGNyZWF0ZSB1c2VyIHUyOw0KQ1JFQVRFIFJPTEUNCg0KdGVz
dD0jIGdyYW50IHNlbGVjdCBvbiBleHRzY2hlbWEudGVzdHRibCB0byB1MjsN
CkdSQU5UDQoNCnRlc3Q9IyBcZHBwIGV4dHNjaGVtYS50ZXN0dGJsDQogICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgQWNjZXNzIHByaXZpbGVnZXMN
CiAgU2NoZW1hICAgfCAgTmFtZSAgIHwgVHlwZSAgfCBBY2Nlc3MgcHJpdmls
ZWdlcyB8IENvbHVtbiBwcml2aWxlZ2VzIHwKUG9saWNpZXMgDQotLS0tLS0t
LS0tLSstLS0tLS0tLS0rLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tKy0t
LS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLQ0KIGV4dHNjaGVtYSB8IHRl
c3R0YmwgfCB0YWJsZSB8IHBpcm89YXJ3ZER4dC9waXJvK3wgICAgICAgICAg
ICAgICAgICAgfCANCiAgICAgICAgICAgfCAgICAgICAgIHwgICAgICAgfCB1
Mj1yL3Bpcm8gICAgICAgICB8ICAgICAgICAgICAgICAgICAgIHwgDQooMSBy
b3cpDQoNCnRlc3Q9IyBpbnNlcnQgaW50byBleHRzY2hlbWEudGVzdHRibCAo
ZGF0YSkgdmFsdWVzICgnYXNkZicpOw0KSU5TRVJUIDAgMQ0KDQoNCjQpIENy
ZWF0ZSBhIG5ldyBkYXRhYmFzZSBhbmQgZHVtcC9yZXN0b3JlIGRhdGEgdGhl
cmUNCg0KdGVzdD0jIGNyZWF0ZSBkYXRhYmFzZSB0ZXN0MjsNCkNSRUFURSBE
QVRBQkFTRQ0KDQokIHBnX2R1bXAgdGVzdCB8IHBzcWwgLTEgdGVzdDINCg0K
DQo1KSBwZXJtaXNzaW9ucyBhcmUgbm90IHJlc3RvcmVkDQoNCnRlc3QyPSMg
XGRwcCBleHRzY2hlbWEudGVzdHRibA0KICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgIEFjY2VzcyBwcml2aWxlZ2VzDQogIFNjaGVtYSAgIHwgIE5h
bWUgICB8IFR5cGUgIHwgQWNjZXNzIHByaXZpbGVnZXMgfCBDb2x1bW4gcHJp
dmlsZWdlcyB8ClBvbGljaWVzIA0KLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0t
LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0t
Ky0tLS0tLS0tLS0NCiBleHRzY2hlbWEgfCB0ZXN0dGJsIHwgdGFibGUgfCAg
ICAgICAgICAgICAgICAgICB8ICAgICAgICAgICAgICAgICAgIHwgDQooMSBy
b3cpDQoNCg0KTm90ZSB0aGF0IHVzaW5nIEFMVEVSIERFRkFVTFQgUFJJVklM
RUdFUyBkb2Vzbid0IHdvcmsgZWl0aGVyOiB0aGUgZGVmYXVsdApwcml2cyBv
biB0aGUgc2NoZW1hcyBhcmUgcmVzdG9yZWQgYWZ0ZXIgdGhlIGV4dGVuc2lv
biBpcyBjcmVhdGVkIHNvIHRoZQp0YWJsZXMgY3JlYXRlZCBieSB0aGUgZXh0
ZW5zaW9ucyBkb24ndCBiZW5lZml0IG9mIGl0LgoK

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14455: pg_upgrade fails with error
Next
From: Stephen Frost
Date:
Subject: Re: BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension