BUG #14192: pg_dump/pg_restore omit setting search_path in restored db - Mailing list pgsql-bugs

From buschmann@nidsa.net
Subject BUG #14192: pg_dump/pg_restore omit setting search_path in restored db
Date
Msg-id 20160615082714.5798.25003@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14192: pg_dump/pg_restore omit setting search_path in restored db
List pgsql-bugs
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE5MgpMb2dnZWQgYnk6ICAg
ICAgICAgIEhhbnMgQnVzY2htYW5uCkVtYWlsIGFkZHJlc3M6ICAgICAgYnVz
Y2htYW5uQG5pZHNhLm5ldApQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4zCk9w
ZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMCA2NGJpdApEZXNjcmlwdGlv
bjogICAgICAgIAoKVG8gdHJhbnNwb3J0IGEgd2hvbGUgZGF0YWJhc2UgZnJv
bSBQcm9kdWN0aW9uIHRvIHRlc3QvZGV2ZWxvcG1lbnQgSSBkdW1wIHRoZQp3
aG9sZSBkYXRhYmFzZSB3aXRoIHBnX2R1bXAgLWQgeHh4ZGIgLUZjIC1mIG15
ZHVtcGZpbGUuZG1wLg0KDQpBZnRlciBjcmVhdGluZyB0aGUgZGF0YWJhc2Ug
b24gdGhlIHRhcmdldCBzeXN0ZW0gd2l0aCBjcmVhdGVkYiBJIHJlc3RvcmUg
dGhlCmRhdGFiYXNlIHdpdGggcGdfcmVzdG9yZSAtZCB4eHhkYiBteWR1bXBm
aWxlLmRtcC4gKG5vIG90aGVyIGZsYWdzIGV4Y2VwdApsb2dpbiBpbmZvcm1h
dGlvbiBpbnZvbHZlZCkNCg0KQWxsIEluZm9ybWF0aW9uIGlzIGNvcnJlY3Rs
eSByZXN0b3JlZCAoMiBzY2hlbWFzIGFuZCB0aGVpciBjb250ZW50KSBleGNl
cHQKdGhlIHNlYXJjaCBwYXRoLg0KDQpPbiB0aGUgb3JpZ2luIGRhdGFiYXNl
IEkgaGFkIGVudGVyZWQNCkFMVEVSIERBVEFCQVNFIHh4eGRiIFNFVCBzZWFy
Y2hfcGF0aCBUTyBwdWJsaWMscGFydGl0aW9uMjsNClRoZSByZXN0b3JlIG9t
aXRzIHNldHRpbmcgdGhlIHNlYXJjaCBwYXRoLCBpdCBtdXN0IGJlIGVudGVy
ZWQgYWdhaW4gd2l0aApBTFRFUiBEQVRBQkFTRSBvbiB0aGUgdGFyZ2V0IG1h
Y2hpbmUuDQoNClRoZSBzYW1lIG9jY3VycyBuYXR1cmFsbHkgYWxzbyBpbiB0
aGUgY2FzZSBvZiBhbiBlbWVyZ2VuY3kgcmVzdG9yZSBpbiBjYXNlCm9mIGZh
aWx1cmUsIHdoaWNoIGJyZWFrcyB0aGUgcmVzdG9yZSBmcm9tIHJ1bm5pbmcg
Y29ycmVjdGx5IHdpdGhvdXQKZXhwZXJ0aXNlIG9mIHRoZSB1bmRlcmx5aW5n
IGRhdGFiYXNlIGluIHRpbWUgb2YgcmVzdG9yYXRpb24uDQoNCldpdGggbXkg
dW5kZXJzdGFuZGluZywgdGhhdCB0aGUgc2VhcmNoIHBhdGggaXMgYW4gaW5o
ZXJlbnQgcGFydCBvZiB0aGUKb3JpZ2luIGRhdGFiYXNlIHN0cnVjdHVyZSwg
dGhlIHBnX2R1bXAvcGdfcmVzdG9yZSBzZXF1ZW5jZSBkb2VzIG5vdApjb21w
bGV0ZWx5IHJlcHJvZHVjZSB0aGUgb3JpZ2luYWwgZGF0YWJhc2UuIEkgdGhp
bmsgdGhpcyBpcyBhIGJ1Zy4NCg0KQWxsIGlzIGRvbmUgb24gOS41LjMsIDY0
Yml0IFdpbmRvd3MgZWRpdGlvbiBvbiBXaW5kb3dzIDY0Yml0IHBsYXRmb3Jt
cywgYnV0Ckkgc3VwcG9zZSBpdCBpcyBwbGF0Zm9ybSBpbmRlcGVuZGVudC4g
SSBoYXZlbid0IHRlc3RlZCBpdCBvbiBkaWZmZXJlbnQKdmVyc2lvbnMgb3Ig
cGxhdGZvcm1zLg0KDQpJIGhhdmVuJ3QgdGVzdGVkIHdoZXRoZXIgcGdfZHVt
cCBvciBwZ19yZXN0b3JlIG9taXRzIHRoZSBzZXR0aW5nIChtb3N0bHkKYmVj
YXVzZSBvZiBub3QgdXNpbmcgYW4gU1FMIGR1bXAgZm9ybWF0KS4NCg0KVGhh
bmtzIGZvciBsb29raW5nDQoKCg==

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #14193: cann't modify composite array's element in plpgsql?
Next
From: Tom Lane
Date:
Subject: Re: BUG #14192: pg_dump/pg_restore omit setting search_path in restored db