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 1jZGzw-0003gE-0U for pgsql-bugs@arkaria.postgresql.org; Thu, 14 May 2020 16:46:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jZGzu-0001pG-RR for pgsql-bugs@arkaria.postgresql.org; Thu, 14 May 2020 16:46:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZGcX-0005hR-Tw for pgsql-bugs@lists.postgresql.org; Thu, 14 May 2020 16:22:05 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jZGcV-0000d3-Fj for pgsql-bugs@lists.postgresql.org; Thu, 14 May 2020 16:22:05 +0000 Content-Type: multipart/mixed; boundary="===============8697878191655140511==" MIME-Version: 1.0 Subject: BUG #16437: The dump is stored with error in creating VIEW statement. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: koktos632@gmail.com Reply-To: koktos632@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 14 May 2020 16:21:25 +0000 Message-ID: <16437-5257db04508943ab@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8697878191655140511== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQzNwpMb2dnZWQgYnk6ICAgICAgICAgIEJvcmlzCkVtYWlsIGFkZHJl c3M6ICAgICAga29rdG9zNjMyQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEyLjIKT3Bl cmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTguMDQKRGVzY3JpcHRpb246ICAgICAgICAKClNvdXJj ZSBzZXJ2ZXI6DQoNClRoZSBkdW1wIHdhcyBjcmVhdGVkIG9uIHRoZSBzZXJ2ZXIgcHNxbCAoMTEu NiAoVWJ1bnR1IDExLjYtMS5wZ2RnMTguMDQrMSkpDQpwb3N0Z3Jlcz0+IHNlbGVjdCB2ZXJzaW9u KCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIHZlcnNpb24gICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDEx LjYgKFVidW50dSAxMS42LTEucGdkZzE4LjA0KzEpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsCmNv bXBpbGVkIGJ5IGdjYyAoVWJ1bnR1IDcuNC4wLTF1YnVudHUxfjE4LjA0LjEpIDcuNC4wLCA2NC1i aXQNCigxIHJvdykNCg0KVGhlIGNvbW1hbmQgdG8gY3JlYXRlIHRoZSBkdW1wIGlzOg0KZGV2dXNl ckB2cHM3NjA1NDI6fi90bXAkIHBnX2R1bXAgLS1maWxlICJjaGFydGJhZXNfJChkYXRlCisiJVkt JW0tJWQtJVQiKS5iYWNrdXAiIC0taG9zdCAibG9jYWxob3N0IiAtLXVzZXJuYW1lICJwb3N0Z3Jl cyIgLS12ZXJib3NlCi0tcXVvdGUtYWxsLWlkZW50aWZpZXJzIC0tZm9ybWF0PWMgLS1uby1wYXNz d29yZCAiY2hhcnRiYWVzIg0KDQoNCkRlc3RpbmF0aW9uIHNlcnZlcjoNCkkgYW0gdXNpbmcgdGhl IGNvbW1hbmQgdG8gcmVzdG9yZSB0aGUgREIgDQpwb3N0Z3Jlcz0jIFwhIHBnX3Jlc3RvcmUgLS1o b3N0ICIxMjcuMC4wLjEiIC0tdXNlcm5hbWUgInBvc3RncmVzIiAgIC1kIHRtcAotLXZlcmJvc2Ug LS1zaW5nbGUtdHJhbnNhY3Rpb24gLS1kaXNhYmxlLXRyaWdnZXJzIC0tc3RyaWN0LW5hbWVzCmNo YXJ0YmFlc18yMDIwLTA1LTE0LTE1XDo1M1w6NDUuYmFja3VwDQoNCi0tLS0tLS0tLS0tLS0tLS0t LQ0KcGdfcmVzdG9yZTogY3JlYXRpbmcgVklFVyAiY3RyYWRlci5zZW50aW1lbnRfc3VtbWFyeV82 MDAiDQpwZ19yZXN0b3JlOiB3aGlsZSBQUk9DRVNTSU5HIFRPQzoNCnBnX3Jlc3RvcmU6IGZyb20g VE9DIGVudHJ5IDI1MjsgMTI1OSAyNTc2OSBWSUVXIHNlbnRpbWVudF9zdW1tYXJ5XzYwMApxdW90 ZWZlZWRlcg0KcGdfcmVzdG9yZTogZXJyb3I6IGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJP UjogIGNvbHVtbgoiX21hdGVyaWFsaXplZF9oeXBlcnRhYmxlXzIuVm9sdW1lIiBtdXN0IGFwcGVh ciBpbiB0aGUgR1JPVVAgQlkgY2xhdXNlIG9yIGJlCnVzZWQgaW4gYW4gYWdncmVnYXRlIGZ1bmN0 aW9uDQpMSU5FIDg6ICAgICAiX21hdGVyaWFsaXplZF9oeXBlcnRhYmxlXzIiLiJWb2x1bWUiLA0K ICAgICAgICAgICAgXg0KQ29tbWFuZCB3YXM6IENSRUFURSBWSUVXICJjdHJhZGVyIi4ic2VudGlt ZW50X3N1bW1hcnlfNjAwIiBBUw0KIFNFTEVDVCAiX21hdGVyaWFsaXplZF9oeXBlcnRhYmxlXzIi LiJUaW1lIiwNCiAgICAiX21hdGVyaWFsaXplZF9oeXBlcnRhYmxlXzIiLiJtX3RpY2tlcklkIiwN CiAgIAoiX3RpbWVzY2FsZWRiX2ludGVybmFsIi4iZmluYWxpemVfYWdnIignZmlyc3QoYW55ZWxl bWVudCwiYW55IiknOjoidGV4dCIsCk5VTEw6OiJuYW1lIiwgTlVMTDo6Im5hbWUiLAone3twZ19j YXRhbG9nLGludDR9LHtwZ19jYXRhbG9nLHRpbWVzdGFtcHR6fX0nOjoibmFtZSJbXSwKIl9tYXRl cmlhbGl6ZWRfaHlwZXJ0YWJsZV8yIi4iYWdnXzNfMyIsIE5VTEw6OmludGVnZXIpIEFTICJPcGVu IiwNCiAgICAiX3RpbWVzY2FsZWRiX2ludGVybmFsIi4iZmluYWxpemVfYWdnIignbWF4KGludGVn ZXIpJzo6InRleHQiLApOVUxMOjoibmFtZSIsIE5VTEw6OiJuYW1lIiwgJ3t7cGdfY2F0YWxvZyxp bnQ0fX0nOjoibmFtZSJbXSwKIl9tYXRlcmlhbGl6ZWRfaHlwZXJ0YWJsZV8yIi4iYWdnXzRfNCIs IE5VTEw6OmludGVnZXIpIEFTICJIaWdoIiwNCiAgICAiX3RpbWVzY2FsZWRiX2ludGVybmFsIi4i ZmluYWxpemVfYWdnIignbWluKGludGVnZXIpJzo6InRleHQiLApOVUxMOjoibmFtZSIsIE5VTEw6 OiJuYW1lIiwgJ3t7cGdfY2F0YWxvZyxpbnQ0fX0nOjoibmFtZSJbXSwKIl9tYXRlcmlhbGl6ZWRf aHlwZXJ0YWJsZV8yIi4iYWdnXzVfNSIsIE5VTEw6OmludGVnZXIpIEFTICJMb3ciLA0KICAgICJf dGltZXNjYWxlZGJfaW50ZXJuYWwiLiJmaW5hbGl6ZV9hZ2ciKCdsYXN0KGFueWVsZW1lbnQsImFu eSIpJzo6InRleHQiLApOVUxMOjoibmFtZSIsIE5VTEw6OiJuYW1lIiwKJ3t7cGdfY2F0YWxvZyxp bnQ0fSx7cGdfY2F0YWxvZyx0aW1lc3RhbXB0en19Jzo6Im5hbWUiW10sCiJfbWF0ZXJpYWxpemVk X2h5cGVydGFibGVfMiIuImFnZ182XzYiLCBOVUxMOjppbnRlZ2VyKSBBUyAiQ2xvc2UiLA0KICAg ICJfbWF0ZXJpYWxpemVkX2h5cGVydGFibGVfMiIuIlZvbHVtZSIsDQogICAgIl90aW1lc2NhbGVk Yl9pbnRlcm5hbCIuImZpbmFsaXplX2FnZyIoJ2NvdW50KCknOjoidGV4dCIsIE5VTEw6OiJuYW1l IiwKTlVMTDo6Im5hbWUiLCAne30nOjoibmFtZSJbXSwgIl9tYXRlcmlhbGl6ZWRfaHlwZXJ0YWJs ZV8yIi4iYWdnXzhfOCIsCk5VTEw6OmJpZ2ludCkgQVMgIkNvdW50Ig0KICAgRlJPTSAiX3RpbWVz Y2FsZWRiX2ludGVybmFsIi4iX21hdGVyaWFsaXplZF9oeXBlcnRhYmxlXzIiDQogIEdST1VQIEJZ ICJfbWF0ZXJpYWxpemVkX2h5cGVydGFibGVfMiIuIlRpbWUiLAoiX21hdGVyaWFsaXplZF9oeXBl cnRhYmxlXzIiLiJtX3RpY2tlcklkIjsNCg0KDQpBYm91dCB0aGUgZGVzdGluYXRpb24gc2VydmVy Og0KDQpwb3N0Z3Jlcz0jIFNFTEVDVCB2ZXJzaW9uKCk7DQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24gICAgICAgCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDEyLjIgKFVidW50dSAxMi4yLTIucGdkZzE4LjA0 KzEpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsCmNvbXBpbGVkIGJ5IGdjYyAoVWJ1bnR1IDcuNC4w LTF1YnVudHUxfjE4LjA0LjEpIDcuNC4wLCA2NC1iaXQNCigxIHJvdykNCg0KcG9zdGdyZXM9IyAN Cg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpFeHBlY3RlZDoNCkRC IGlzIHJlc3RvcmVkIGZyb20gdGhlIGR1bXAgb24gdGhlIGRlc3RpbmF0aW9uIHNlcnZlci4NCkFj dHVhbDoNClRoZSBjb21tYW5kICJDUkVBVEUgVklFVyAiY3RyYWRlciIuInNlbnRpbWVudF9zdW1t YXJ5XzYwMC4uLiIgZmFpbHMgdG8KY3JlYXRlIHRoZSBvYmplY3QuDQoNCkFsbCByZXF1aXJlZCBt b2R1bGVzIGFyZSBpbnN0YWxsZWQgb24gYm90aCBzZXJ2ZXJzLg0KDQpSZWdhcmRzLA0KQm9yaXMu Cgo= --===============8697878191655140511==--