Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ipyFZ-0007Vh-QR for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Jan 2020 17:39:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ipyFY-0003Zs-Fm for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Jan 2020 17:39:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ipyFY-0003Zk-7l for pgsql-bugs@lists.postgresql.org; Fri, 10 Jan 2020 17:39:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ipyFV-0007qR-Ud for pgsql-bugs@lists.postgresql.org; Fri, 10 Jan 2020 17:39:07 +0000 Content-Type: multipart/mixed; boundary="===============7008771813924165078==" MIME-Version: 1.0 Subject: BUG #16202: Cannot restore database that has materialized view using crosstab (tablefunc) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: wagner.engel@gmail.com Reply-To: wagner.engel@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 10 Jan 2020 17:38:05 +0000 Message-ID: <16202-b6b345c9d2819409@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============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==--