BUG #16202: Cannot restore database that has materialized view using crosstab (tablefunc)
PG Bug reporting form <[email protected]> Fri, 10 Jan 2020 17:38:05 +0000
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <[email protected]> |
--===============7008771813924165078== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjIwMgpMb2dnZWQgYnk6ICAgICAgICAgIFdhZ25lciBFbmdlbApFbWFp bCBhZGRyZXNzOiAgICAgIHdhZ25lci5lbmdlbEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxMi4xCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIDEwCkRlc2NyaXB0aW9uOiAgICAgICAg CgpJZiBJIGJ1aWxkIGEgbWF0ZXJpemFsaXplZCB2aWV3IHRoYXQgdXNlcyB0aGUgY3Jvc3N0YWIo KSBmdW5jdGlvbiwgYQpkdW1wL3Jlc3RvcmUgY3ljbGUgd2lsbCBub3QgcmVzdG9yZSB0aGUgZGF0 YWJhc2UuDQpBIHNpbXBsZSB0ZXN0IGNhc2UgaXM6DQoNCmNyZWF0ZS5zcWw6DQotLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KQ1JFQVRFIEVYVEVOU0lPTiB0YWJsZWZ1bmM7DQoNCkNS RUFURSBUQUJMRSB0ICgNCglpZCBJTlRFR0VSDQopOw0KDQpDUkVBVEUgVklFVyB2IEFTDQpTRUxF Q1QgKiBGUk9NIGNyb3NzdGFiICgNCgknU0VMRUNUIGlkIEZST00gdCBhcyB0MScsDQoJJ1NFTEVD VCBpZCBGUk9NIHQgYXMgdDInDQopIGN0IChhIGludGVnZXIsIGIgaW50ZWdlcik7DQoNCkNSRUFU RSBNQVRFUklBTElaRUQgVklFVyBtdiBBUw0KU0VMRUNUICogRlJPTSB2Ow0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KJCBjcmVhdGVkYiAtaCBsb2NhbGhvc3QgLVUgcG9zdGdy ZXMgYWJjDQokIHBzcWwgLWggbG9jYWxob3N0IC1VIHBvc3RncmVzIGFiYyA8IGNyZWF0ZS5zcWwN CkNSRUFURSBFWFRFTlNJT04NCkNSRUFURSBUQUJMRQ0KQ1JFQVRFIFZJRVcNClNFTEVDVCAwDQok IHBnX2R1bXAgLS1ob3N0IGxvY2FsaG9zdCAtLXVzZXJuYW1lICJwb3N0Z3JlcyIgLS1mb3JtYXQg cGxhaW4gLS1maWxlCmFiYy5zcWwgYWJjDQokIGNyZWF0ZWRiIC1oIGxvY2FsaG9zdCAtVSBwb3N0 Z3JlcyBhYmMyDQokIHBzcWwgLWggbG9jYWxob3N0IC1VIHBvc3RncmVzIGFiYzIgPCBhYmMuc3Fs DQpTRVQNClNFVA0KU0VUDQpTRVQNClNFVA0KIHNldF9jb25maWcgDQotLS0tLS0tLS0tLS0NCiAN CigxIHJvdykNCg0KU0VUDQpTRVQNClNFVA0KU0VUDQpDUkVBVEUgRVhURU5TSU9ODQpDT01NRU5U DQpDUkVBVEUgVklFVw0KQUxURVIgVEFCTEUNClNFVA0KU0VUDQpDUkVBVEUgTUFURVJJQUxJWkVE IFZJRVcNCkFMVEVSIFRBQkxFDQpDUkVBVEUgVEFCTEUNCkFMVEVSIFRBQkxFDQpDT1BZIDANCkVS Uk9SOiAgcmVsYXRpb24gInQiIGRvZXMgbm90IGV4aXN0DQpMSU5FIDE6IFNFTEVDVCBpZCBGUk9N IHQgYXMgdDINCiAgICAgICAgICAgICAgICAgICAgICAgXg0KUVVFUlk6ICBTRUxFQ1QgaWQgRlJP TSB0IGFzIHQyDQoNCg0KDQpVc2luZyBmb3JtYXQgY3VzdG9tIGFuZCBwZ19yZXN0b3JlIGFsc28g ZmFpbHM6DQoNCiQgcGdfZHVtcCAtLWhvc3QgbG9jYWxob3N0IC0tdXNlcm5hbWUgInBvc3RncmVz IiAtLWZvcm1hdCBjdXN0b20gLS1maWxlCmFiYy5iYWNrdXAgYWJjDQokIGNyZWF0ZWRiIC1oIGxv Y2FsaG9zdCAtVSBwb3N0Z3JlcyBhYmMzDQokIHBnX3Jlc3RvcmUgLS1ob3N0IGxvY2FsaG9zdCAt LXVzZXJuYW1lICJwb3N0Z3JlcyIgLWQgYWJjMyBhYmMuYmFja3VwIA0KcGdfcmVzdG9yZTogd2hp bGUgUFJPQ0VTU0lORyBUT0M6DQpwZ19yZXN0b3JlOiBmcm9tIFRPQyBlbnRyeSAyOTAxOyAwIDEw OTQxMjkgTUFURVJJQUxJWkVEIFZJRVcgREFUQSBtdgpwb3N0Z3Jlcw0KcGdfcmVzdG9yZTogZXJy b3I6IGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjogIHJlbGF0aW9uICJ0IiBkb2VzIG5v dApleGlzdA0KTElORSAxOiBTRUxFQ1QgaWQgRlJPTSB0IGFzIHQyDQogICAgICAgICAgICAgICAg ICAgICAgIF4NClFVRVJZOiAgU0VMRUNUIGlkIEZST00gdCBhcyB0Mg0KQ29tbWFuZCB3YXM6IFJF RlJFU0ggTUFURVJJQUxJWkVEIFZJRVcgcHVibGljLm12Ow0KDQoNCnBnX3Jlc3RvcmU6IHdhcm5p bmc6IGVycm9ycyBpZ25vcmVkIG9uIHJlc3RvcmU6IDENCg0KDQoNCkV4dHJhOg0KV2l0aGluIHRo ZSBhYmMuc3FsIGR1bXAsIHRoZSBDUkVBVEUgVEFCTEUgY29tbWFuZCBpcyBhZnRlciBib3RoIGNy ZWF0ZSB2aWV3CmNvbW1hbmRzLiBNb3ZpbmcgaXQgYmVmb3JlIG1ha2VzIG5vIGRpZmZlcmVuY2Uu DQoNCg0KDQpWZXJzaW9uczoNCiQgcGdfZHVtcCAtVg0KcGdfZHVtcCAoUG9zdGdyZVNRTCkgMTIu MSAoRGViaWFuIDEyLjEtMS5wZ2RnMTAwKzEpDQokIHBnX3Jlc3RvcmUgLVYNCnBnX3Jlc3RvcmUg KFBvc3RncmVTUUwpIDEyLjEgKERlYmlhbiAxMi4xLTEucGdkZzEwMCsxKQ0KJCBwc3FsIC1WDQpw c3FsIChQb3N0Z3JlU1FMKSAxMi4xIChEZWJpYW4gMTIuMS0xLnBnZGcxMDArMSkNCiQgcHNxbCAt aCBsb2NhbGhvc3QgLVUgcG9zdGdyZXMgYWJjIC1jICJTRUxFQ1QgdmVyc2lvbigpOyINCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdmVyc2lvbiAg ICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQog UG9zdGdyZVNRTCAxMi4xIChEZWJpYW4gMTIuMS0xLnBnZGcxMDArMSkgb24geDg2XzY0LXBjLWxp bnV4LWdudSwgY29tcGlsZWQKYnkgZ2NjIChEZWJpYW4gOC4zLjAtNikgOC4zLjAsIDY0LWJpdA0K KDEgcm93KQoK --===============7008771813924165078==--