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 1lPAd2-0003eX-D7 for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Mar 2021 21:01:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lPAd0-0000pp-0l for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Mar 2021 21:01:22 +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 1lPAHH-0003Gd-GQ for pgsql-bugs@lists.postgresql.org; Wed, 24 Mar 2021 20:38:55 +0000 Received: from forward103p.mail.yandex.net ([2a02:6b8:0:1472:2741:0:8b7:106]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPAHF-00050c-Ed for pgsql-bugs@lists.postgresql.org; Wed, 24 Mar 2021 20:38:55 +0000 Received: from iva1-9e0def03149c.qloud-c.yandex.net (iva1-9e0def03149c.qloud-c.yandex.net [IPv6:2a02:6b8:c0c:9281:0:640:9e0d:ef03]) by forward103p.mail.yandex.net (Yandex) with ESMTP id C748F18C1443 for ; Wed, 24 Mar 2021 23:38:50 +0300 (MSK) Received: from mail.yandex.ru (mail.yandex.ru [188.227.10.2]) by iva1-9e0def03149c.qloud-c.yandex.net (mxback/Yandex) with HTTP id dcpr7301tuQ1-co1eGfKq; Wed, 24 Mar 2021 23:38:50 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1616618330; bh=g/zGPvioY2FWs3z4NCPkkc3yottIXsU2hESWpB3Fxn8=; h=Date:Message-Id:Subject:In-Reply-To:To:From; b=bmQKDI9WMGZCKBmG3ea+lblmQI5UDJYfhteDwzwipnVk9DRWnrwgdmo4zEszBrACV 3502Av24fQ+QI9ik4j5x+9R28IaptdXkWlFc6MSytoayxRDACwPBw7KMHKqSacAuHX cVnMxwoo81SnXnepTdBWeHXFOzw76TUGV9FOUOgY= Authentication-Results: iva1-9e0def03149c.qloud-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by iva5-4e96f110c519.qloud-c.yandex.net with HTTP; Wed, 24 Mar 2021 23:38:50 +0300 From: Boris P. Korzun Envelope-From: drtr0jan@yandex.ru To: "pgsql-bugs@lists.postgresql.org" In-Reply-To: <7161616616624@mail.yandex.ru> Subject: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 24 Mar 2021 23:38:50 +0300 Message-Id: <111621616618184@mail.yandex.ru> Content-Type: multipart/mixed; boundary="----==--bound.1064580.iva5-4e96f110c519.qloud-c.yandex.net" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------==--bound.1064580.iva5-4e96f110c519.qloud-c.yandex.net Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 PGRpdj5IaSw8L2Rpdj48ZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjxkaXY+UG9zdGdyZVNRTCB2ZXJz aW9uOiAxMy4yPC9kaXY+PGRpdj5PcGVyYXRpbmcgc3lzdGVtOiDCoEZyZWVCU0QgMTMtU1RBQkxF PC9kaXY+PGRpdj7CoDwvZGl2PjwvZGl2PjxkaXY+SSd2ZSBmb3VuZGVkIHRoYXQgcGdfZHVtcCAo YW5kIHBnX2R1bXBhbGwpIGluY29ycmVjdGx0eSBleHBvcnRzIHN1YnNlcXVlbnQgZGVmYXVsdCBw cml2aWxlZ2VzLjwvZGl2PjxkaXY+RXguOjwvZGl2PjxkaXY+Jmd0OyBBTFRFUiBERUZBVUxUIFBS SVZJTEVHRVMgRk9SIFJPTEUgcG9zdGdyZXMgUkVWT0tFIEFMTCBPTiBGVU5DVElPTlMgRlJPTSBQ VUJMSUM7PC9kaXY+PGRpdj4mZ3Q7IEFMVEVSIERFRkFVTFQgUFJJVklMRUdFUyBGT1IgUk9MRSBw b3N0Z3JlcyBJTiBTQ0hFTUEgYmFyIEdSQU5UIEVYRUNVVEUgT04gRlVOQ1RJT05TIFRPIFBVQkxJ Qzs8L2Rpdj48ZGl2PiZndDsgYnVnPSMgXGRkcDwvZGl2PjxkaXY+Jmd0OyDCoCDCoCDCoCDCoCDC oCDCoCDCoERlZmF1bHQgYWNjZXNzIHByaXZpbGVnZXM8L2Rpdj48ZGl2PiZndDsgwqAgT3duZXIg wqAgfCBTY2hlbWEgfCDCoCBUeXBlIMKgIHwgwqBBY2Nlc3MgcHJpdmlsZWdlczwvZGl2PjxkaXY+ Jmd0OyAtLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0t PC9kaXY+PGRpdj4mZ3Q7IMKgcG9zdGdyZXMgfCBiYXIgwqAgwqB8IGZ1bmN0aW9uIHwgPVgvcG9z dGdyZXM8L2Rpdj48ZGl2PiZndDsgwqBwb3N0Z3JlcyB8IMKgIMKgIMKgIMKgfCBmdW5jdGlvbiB8 IHBvc3RncmVzPVgvcG9zdGdyZXM8L2Rpdj48ZGl2PiZndDsgLS0gSSBjYW4gZXhlY3V0ZSBuZXds eSBjcmVhdGVkIGZ1bmN0aW9ucyBvbiBzY2hlbWUgJ2JhcicgYWZ0ZXIgdGhhdC48L2Rpdj48ZGl2 PsKgPC9kaXY+PGRpdj53aWxsIGJlIGV4cG9ydGVkIGFzOjwvZGl2PjxkaXY+Jmd0OyBBTFRFUiBE RUZBVUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUgcG9zdGdyZXMgSU4gU0NIRU1BIGJhciBSRVZPS0Ug QUxMIE9OIEZVTkNUSU9OUyDCoEZST00gcG9zdGdyZXM7PC9kaXY+PGRpdj4mZ3Q7IEFMVEVSIERF RkFVTFQgUFJJVklMRUdFUyBGT1IgUk9MRSBwb3N0Z3JlcyBSRVZPS0UgQUxMIE9OIEZVTkNUSU9O UyDCoEZST00gUFVCTElDOzwvZGl2PjxkaXY+Jmd0OyBidWc9IyBcZGRwPC9kaXY+PGRpdj4mZ3Q7 IMKgIMKgIMKgIMKgIMKgIMKgIMKgRGVmYXVsdCBhY2Nlc3MgcHJpdmlsZWdlczwvZGl2PjxkaXY+ Jmd0OyDCoCBPd25lciDCoCB8IFNjaGVtYSB8IMKgIFR5cGUgwqAgfCDCoEFjY2VzcyBwcml2aWxl Z2VzIMKgPC9kaXY+PGRpdj4mZ3Q7IC0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tLS0tLS08L2Rpdj48ZGl2PiZndDsgwqBwb3N0Z3JlcyB8IMKgIMKgIMKgIMKg fCBmdW5jdGlvbiB8IHBvc3RncmVzPVgvcG9zdGdyZXM8L2Rpdj48ZGl2PiZndDsgLS0gSSBjYW4g Tk9UIGV4ZWN1dGUgbmV3bHkgY3JlYXRlZCBmdW5jdGlvbnMgb24gc2NoZW1lICdiYXInIGFmdGVy IHRoYXQuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+QWZ0ZXIgcmVzdG9yaW5nIHRoZSBkdW1wIEkg Y2Fubm90IGV4ZWN1dGUgbmV3bHkgY3JlYXRlZCBmdW5jdGlvbnMgb24gc2NoZW1lICdiYXInLjwv ZGl2PjxkaXY+SSd2ZSBhdHRhY2hlZCB0aGUgc2hlbGwtc2NyaXB0IHRoYXQgY3JlYXRlIHRoZSBl bnZpcm9ubWVudC48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5JIGNyZWF0ZSBhIGZ1bmN0aW9uIGFm dGVyIGR1bXAgb3IgcmVzdG9yZSBwcm9jZWR1cmVzIChleC4gYmFja3VwIHB1cnBvc2VzKTo8L2Rp dj48ZGl2PjxkaXY+Jmd0OyBDUkVBVEUgRlVOQ1RJT04gYmFyLm5ldygpIFJFVFVSTlMgYm9vbDwv ZGl2PjxkaXY+Jmd0OyDCoCDCoCBJTU1VVEFCTEU8L2Rpdj48ZGl2PiZndDsgwqAgwqAgTEFOR1VB R0Ugc3FsPC9kaXY+PGRpdj4mZ3Q7IEFTICdTRUxFQ1QgVFJVRTsnOzwvZGl2PjxkaXY+VGhlIGZ1 bmN0aW9uIGJhci5uZXcoKSBjYW5ub3QgYmUgZXhlY3V0ZWQgYnkgJ2J1ZycgdXNlciBpZiBjcmVh dGVkIGFmdGVyIHRoZSByZXN0b3JlIHByb2NlZHVyZS48L2Rpdj48ZGl2PkkndmUgZ290IGFuIGVy cm9yOiBFUlJPUjogwqBwZXJtaXNzaW9uIGRlbmllZCBmb3IgZnVuY3Rpb24gbmV3LjwvZGl2Pjxk aXY+wqA8L2Rpdj48L2Rpdj48ZGl2PldCUiw8L2Rpdj48ZGl2PkJvcmlzPC9kaXY+PC9kaXY+ ------==--bound.1064580.iva5-4e96f110c519.qloud-c.yandex.net Content-Disposition: attachment; filename="sql-def_priv_bug.sh" Content-Transfer-Encoding: base64 Content-Type: text/x-shellscript; name="sql-def_priv_bug.sh" IyEvYmluL3NoCgpQU1FMPSJwc3FsIC12IE9OX0VSUk9SX1NUT1A9MSIKCmV4cG9ydCBQR1VTRVI9 InBvc3RncmVzIgpleHBvcnQgUEdIT1NUPSIxMjcuMC4wLjEiCmV4cG9ydCBQR1BPUlQ9IjU0MzIi CmV4cG9ydCBQR1NTTE1PREU9ImRpc2FibGUiCgpleHBvcnQgUEdEQVRBQkFTRT0idGVtcGxhdGUx IgpleHBvcnQgUEdVU0VSPSJwb3N0Z3JlcyIKCiR7UFNRTH0gPDwgRSpPKkYgfHwgZXhpdCAxClNF TEVDVCBwZ190ZXJtaW5hdGVfYmFja2VuZChwaWQpCkZST00gcGdfc3RhdF9hY3Rpdml0eQpXSEVS RSBkYXRuYW1lID0gJ2J1ZycKICBBTkQgcGlkIDw+IHBnX2JhY2tlbmRfcGlkKCk7CgpEUk9QIERB VEFCQVNFIElGIEVYSVNUUyAiYnVnIjsKCkRST1AgUk9MRSBJRiBFWElTVFMgImJ1ZyI7CkNSRUFU RSBST0xFICJidWciIE5PSU5IRVJJVCBMT0dJTiBCWVBBU1NSTFMgUEFTU1dPUkQgJzEyMzQ1Nic7 CgpDUkVBVEUgREFUQUJBU0UgImJ1ZyI7CkUqTypGCgpleHBvcnQgUEdEQVRBQkFTRT0iYnVnIgpl eHBvcnQgUEdVU0VSPSJwb3N0Z3JlcyIKCiR7UFNRTH0gLXEgPDwgRSpPKkYgfHwgZXhpdCAxCkFM VEVSIERFRkFVTFQgUFJJVklMRUdFUyBSRVZPS0UgQUxMIE9OIEZVTkNUSU9OUyBGUk9NIFBVQkxJ QzsKCkNSRUFURSBTQ0hFTUEgZm9vOwpHUkFOVCBVU0FHRSBPTiBTQ0hFTUEgZm9vIFRPICJidWci OwpDUkVBVEUgRlVOQ1RJT04gZm9vLmZvbygpIFJFVFVSTlMgYm9vbAogICAgSU1NVVRBQkxFCiAg ICBMQU5HVUFHRSBzcWwKQVMKXCRfXCQKU0VMRUNUIFRSVUU7ClwkX1wkOwoKQ1JFQVRFIFNDSEVN QSBiYXI7CkdSQU5UIFVTQUdFIE9OIFNDSEVNQSBiYXIgVE8gImJ1ZyI7CkFMVEVSIERFRkFVTFQg UFJJVklMRUdFUyBJTiBTQ0hFTUEgYmFyIEdSQU5UIEVYRUNVVEUgT04gRlVOQ1RJT05TIFRPIFBV QkxJQzsKQ1JFQVRFIEZVTkNUSU9OIGJhci5iYXIoKSBSRVRVUk5TIGJvb2wKICAgIElNTVVUQUJM RQogICAgTEFOR1VBR0Ugc3FsCkFTClwkX1wkClNFTEVDVCBGQUxTRTsKXCRfXCQ7CkUqTypG ------==--bound.1064580.iva5-4e96f110c519.qloud-c.yandex.net--