Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nrewI-0001RH-0i for pgsql-bugs@arkaria.postgresql.org; Thu, 19 May 2022 12:07:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nrewG-0005Vd-SK for pgsql-bugs@arkaria.postgresql.org; Thu, 19 May 2022 12:07:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nret4-0000mJ-3x for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 12:04:14 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nresx-0007uG-A8 for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 12:04:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=yLOOW1Ul34Y+PUgh9amRPXAF6jt3CD4naDQhN/ucOwg=; b=05MbCRG/MBYgxIIbSikoVfmMIU S+aT27cNdbnsiX7EBgBKl2JcXtd4pUBJbA4jbcLQi2VaMcO4xY37bNrIeadxDKA//R5XV15nORnYR 3tpczZkwQxpkLwuzT/X5P5Ey84z6pLs/DqjcBS5WRCIEa9jAsrAJoeRHRGqkqRxnxQ1Ft2dHWkEfb W/LzCsVLd1QD24xG/F2uX4siEbgA5gALrzLFStk6vBeBLwaYV3XY2j05gmn7QkVagbfO5oWqqGzg4 IDQdmXOuBGa803+gSRl8mWSA7W3OLaq1ZBnhQncxEs8baNNQCGJyc7eZd6boNm2L01zy9WxPZnrtL 2oVPgM0w==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nresw-0000XF-9N for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 12:04:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nress-000RQM-6w for pgsql-bugs@lists.postgresql.org; Thu, 19 May 2022 12:04:02 +0000 Content-Type: multipart/mixed; boundary="===============3359523358515132962==" MIME-Version: 1.0 Subject: BUG #17486: [pg_restore] Restoring a view fails if this view contains an attribute without alias name. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: n.lutic@loxodata.com Reply-To: n.lutic@loxodata.com, pgsql-bugs@lists.postgresql.org Date: Thu, 19 May 2022 12:03:37 +0000 Message-ID: <17486-1ad6fd786728b8af@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3359523358515132962== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ4NgpMb2dnZWQgYnk6ICAgICAgICAgIE5pY29sYXMgTHV0aWMKRW1h aWwgYWRkcmVzczogICAgICBuLmx1dGljQGxveG9kYXRhLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE0LjMKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTEKRGVzY3JpcHRpb246ICAgICAgICAK CkhpIFRlYW0sDQoNCkkgZm91bmQgc29tZXRoaW5nIHdlaXJkLiBSZXN0b3JpbmcgYSB2aWV3IGZh aWxzIGlmIHRoaXMgdmlldyBjb250YWlucyBhbgphdHRyaWJ1dGUgd2l0aG91dCBhbGlhcyBuYW1l Lg0KDQpQbGVhc2UgZmluZCBiZWxvdyB0aGUgZGV0YWlscyB0byByZXByb2R1Y2UgdGhlIHByb2Js ZW06IA0KDQogICAgcHNxbCAtaCBsb2NhbGhvc3QgLWMgJ0NSRUFURSBEQVRBQkFTRSBkZW1vOycN Cg0KICAgIHBzcWwgLWggbG9jYWxob3N0IC1kIGRlbW8NCiAgICANCiAgICBkZW1vPSMgQ1JFQVRF IFZJRVcgdl9zdGF0aWNfc2VsZWN0IGFzIA0KICAgIFdJVEggc3RhdGljX3NlbGVjdCBhcyAoDQog ICAgICAgIHNlbGVjdCANCiAgICAgICAgICAgIDEgIGFzIGZvbywNCiAgICAgICAgICAgICd0ZXh0 Jw0KICAgICkNCiAgICBzZWxlY3QgKiBmcm9tIHN0YXRpY19zZWxlY3Q7DQogICAgDQogICAgDQog ICAgZGVtbz0jIFxkKyB2X3N0YXRpY19zZWxlY3QgDQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgVmlldyAicHVibGljLnZfc3RhdGljX3NlbGVjdCINCiAgICAgIENvbHVtbiAgfCAgVHlwZSAg IHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSAgfApEZXNjcmlwdGlv biANCiAgIAotLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0t LS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0NCiAgICAgZm9vICAgICAgfCBpbnRlZ2VyIHwg ICAgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgIHwgcGxhaW4gICAgfCANCiAgICAgP2NvbHVt bj8gfCB0ZXh0ICAgIHwgICAgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgIHwgZXh0ZW5kZWQg fCANCiAgICBWaWV3IGRlZmluaXRpb246DQogICAgIFdJVEggc3RhdGljX3NlbGVjdCBBUyAoDQog ICAgICAgICAgICAgU0VMRUNUIDEgQVMgZm9vLA0KICAgICAgICAgICAgICAgICd0ZXh0Jzo6dGV4 dA0KICAgICAgICAgICAgKQ0KICAgICBTRUxFQ1Qgc3RhdGljX3NlbGVjdC5mb28sDQogICAgICAg IHN0YXRpY19zZWxlY3QuIj9jb2x1bW4/Ig0KICAgICAgIEZST00gc3RhdGljX3NlbGVjdDsNCg0K DQogICAgZGVtbz0jIHNlbGVjdCAqIGZyb20gdl9zdGF0aWNfc2VsZWN0Ow0KICAgIGZvbyB8ID9j b2x1bW4/IA0KICAgIC0tLS0tKy0tLS0tLS0tLS0NCiAgICAxIHwgdGV4dA0KICAgICgxIHJvdykN Cg0KDQogICAgcGdfZHVtcCAtaCBsb2NhbGhvc3QgLXA1NDMyIC1VIHBvc3RncmVzIC1kIGRlbW8g LUZjIC1mIC90bXAvZGVtby5kdW1wDQoNCiAgICBwc3FsIC1oIGxvY2FsaG9zdCAtcDU0MzIgLVUg cG9zdGdyZXMgLWQgZGVtbyAtYyAnRFJPUCBWSUVXCnZfc3RhdGljX3NlbGVjdCA7Jw0KDQogICAg cGdfcmVzdG9yZSAtcyAtaCBsb2NhbGhvc3QgLXA1NDMyIC1VIHBvc3RncmVzIC1kIGRlbW8gIC90 bXAvZGVtby5kdW1wIA0KICAgIA0KICAgIHBnX3Jlc3RvcmU6IGVycm9yOiBjb3VsZCBub3QgZXhl Y3V0ZSBxdWVyeTogRVJST1I6ICBjb2x1bW4Kc3RhdGljX3NlbGVjdC4/Y29sdW1uPyBkb2VzIG5v dCBleGlzdA0KICAgIExJTkUgNzogICAgIHN0YXRpY19zZWxlY3QuIj9jb2x1bW4/Ig0KICAgICAg ICAgICAgXg0KICAgIENvbW1hbmQgd2FzOiBDUkVBVEUgVklFVyBwdWJsaWMudl9zdGF0aWNfc2Vs ZWN0IEFTDQogICAgIFdJVEggc3RhdGljX3NlbGVjdCBBUyAoDQogICAgICAgICBTRUxFQ1QgMSBB UyBmb28sDQogICAgICAgICAgICAndGV4dCc6OnRleHQNCiAgICAgICAgKQ0KICAgICBTRUxFQ1Qg c3RhdGljX3NlbGVjdC5mb28sDQogICAgICAgIHN0YXRpY19zZWxlY3QuIj9jb2x1bW4/Ig0KICAg ICAgIEZST00gc3RhdGljX3NlbGVjdDsNCiAgICAgICANCg0KUmVnYXJkcywgTmljb2xhcyBMdXRp YwoK --===============3359523358515132962==--