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 1iVjty-0005Ac-IB for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Nov 2019 22:17:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iVjtw-0008WO-Qo for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Nov 2019 22:17:12 +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 1iVjtw-0008WH-J0 for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2019 22:17:12 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iVjtp-0006P1-M8 for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2019 22:17:12 +0000 Content-Type: multipart/mixed; boundary="===============5279262069763628009==" MIME-Version: 1.0 Subject: BUG #16119: pg_dump omits columns specification for matviews To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dmitry.telpt@gmail.com Reply-To: dmitry.telpt@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 15 Nov 2019 22:16:51 +0000 Message-ID: <16119-e64823f30a45a754@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5279262069763628009== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjExOQpMb2dnZWQgYnk6ICAgICAgICAgIERtaXRyeSBUZWxwdApFbWFp bCBhZGRyZXNzOiAgICAgIGRtaXRyeS50ZWxwdEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiA5LjQuMjUKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eC9Eb2NrZXIKRGVzY3JpcHRpb246ICAg ICAgICAKCkhpIHRoZXJlLA0KDQpXZSd2ZSBmYWNlZCB1cCB3aXRoIGFuIGlzc3VlIGhvdyBwZ19k dW1wIGV4cG9ydHMgbWF0ZXJpYWx6ZWQgdmlld3MsIGl0CmRvZXNuJ3QgZXhwb3J0IGNvbHVtbnMg ZGVjbGFyYXRpb24gdGhhdCBpcyBsZWdhbCBwYXJhbWV0ZXIgb2YgQ1JFQVRFIERETAppbnN0cnVj dGlvbi4NCkFzIEkgY2FuIHNlZSBmcm9tIGRiX2R1bXAgc291cmNlLCBpdCdzIGludGVudCBiZWhh dmlvdXIgYW5kIHN1cHBvc2VkIHRoYXQKY29sdW1ucyBkZWNsYXJpb24gd2lsbCBiZSBwaWNrZWQg dXAgZnJvbSBxdWVyeSBzdGF0ZW1lbnQgd2hlbiBtYXR2aWV3IGlzCmNyZWF0ZWQgYnkgdGFyZ2V0 IGluc3RhbmNlLiBIb3dldmVyLCBpZiBtYXR2aWV3IGlzICdzdGF0aWMnIChkb2Vzbid0IGhhdmUg YQpxdWVyeSBzdGF0ZW1lbnQpLCBpdCBzZXRzIGRlZmF1bHQgY29sdW1uIG5hbWVzIChjb2x1bW4x LCBjb2x1bW4yLCBldGMpIHRoYXQKYnJlYWtzIGFsbCBkZXBlbmRlbnQgdGFibGVzL3ZpZXdzL21h dHZpZXdzLCBmb3IgaW5zdGFuY2U6DQoNCnBvc3RncmVzPT4gQ1JFQVRFIE1BVEVSSUFMSVpFRCBW SUVXIHRlc3RfbXYNCiAgKGlkLCBhbGlhcykgQVMNCiAgVkFMVUVTICgxLCA1KSwgKDIsIDYpLCAo MywgMTcpDQo7DQpTRUxFQ1QgMw0KcG9zdGdyZXM9PiBcZCsgdGVzdF9tdg0KICAgICAgICAgICAg ICAgICBNYXRlcmlhbGl6ZWQgdmlldyAicHVibGljLnRlc3RfbXYiDQogQ29sdW1uIHwgIFR5cGUg ICB8IE1vZGlmaWVycyB8IFN0b3JhZ2UgfCBTdGF0cyB0YXJnZXQgfCBEZXNjcmlwdGlvbiANCi0t LS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLQ0KIGlkICAgICB8IGludGVnZXIgfCAgICAgICAgICAgfCBwbGFpbiAgIHwgICAg ICAgICAgICAgIHwgDQogYWxpYXMgIHwgaW50ZWdlciB8ICAgICAgICAgICB8IHBsYWluICAgfCAg ICAgICAgICAgICAgfCANClZpZXcgZGVmaW5pdGlvbjoNCiBWQUxVRVMgKDEsNSksICgyLDYpLCAo MywxNyk7DQoNCg0KYnV0IHBnX2R1bXAgcHJvZHVjZXMgdGhlIGZvbGxvd2luZyBEREwgc3RhdGVt ZW50Og0KLS0NCi0tIE5hbWU6IHRlc3RfbXY7IFR5cGU6IE1BVEVSSUFMSVpFRCBWSUVXOyBTY2hl bWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzDQotLQ0KDQpDUkVBVEUgTUFURVJJQUxJWkVEIFZJ RVcgcHVibGljLnRlc3RfbXYgQVMNCiBWQUxVRVMgKDEsNSksICgyLDYpLCAoMywxNykNCiAgV0lU SCBOTyBEQVRBOw0KDQp0aGF0IGxlYWRzIHRvIHRoZSBmb2xsb3dpbmcgZGVjbGFyYXRpb24gaW4g dGFyZ2V0IGluc3RhbmNlOg0KcG9zdGdyZXM9PiBcZCsgdGVzdF9tdg0KICAgICAgICAgTWF0ZXJp YWxpemVkIHZpZXcgInB1YmxpYy50ZXN0X212Ig0KIENvbHVtbiAgfCAgVHlwZSAgIHwgTW9kaWZp ZXJzIHwgU3RvcmFnZSB8IFN0YXRzIHRhcmdldCB8IERlc2NyaXB0aW9uIA0KLS0tLS0tLS0tKy0t LS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LQ0KIGNvbHVtbjEgfCBpbnRlZ2VyIHwgICAgICAgICAgIHwgcGxhaW4gICB8ICAgICAgICAgICAg ICB8IA0KIGNvbHVtbjIgfCBpbnRlZ2VyIHwgICAgICAgICAgIHwgcGxhaW4gICB8ICAgICAgICAg ICAgICB8IA0KVmlldyBkZWZpbml0aW9uOg0KIFZBTFVFUyAoMSw1KSwgKDIsNiksICgzLDE3KTsN Cg0KdGhlIHZlcnNpb24gb2YgZW5naW5lIG9yIGRiX2R1bXAgZG9lc24ndCBtYXR0ZXIsIHRoZSBz YW1lIGJlaGF2aW9yLg0KDQppdCdzIG1pbm9yIGJ1Zywgc2luY2UgZHVtcCBmaWxlIG1heSBiZSBm aXhlZCBtYW51YWxseSBiZWZvcmUgcmVzdG9yaW5nIGJ1dAp3aGVuIHlvdSBkb24ndCBoYXZlIGFj Y2VzcyB0byBmaWxlIChmb3IgaW5zdGFuY2UsIEFXUyBSRFMgdXBncmFkZQpwcm9jZWR1cmUpLCBp dCBiZWNvbWVzIHZlcnkgcGFpbmZ1bC4NCg0KVGhhbmtzLA0KRG1pdHJ5Cgo= --===============5279262069763628009==--