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 1hLye6-00031j-O3 for pgsql-bugs@arkaria.postgresql.org; Wed, 01 May 2019 23:28: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 1hLye5-0003U2-9h for pgsql-bugs@arkaria.postgresql.org; Wed, 01 May 2019 23:28:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLye4-0003Tv-So for pgsql-bugs@lists.postgresql.org; Wed, 01 May 2019 23:28:13 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLye2-0002kZ-4w for pgsql-bugs@lists.postgresql.org; Wed, 01 May 2019 23:28:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1556753290; x=1588289290; h=from:to:subject:date:message-id:references:in-reply-to: mime-version; bh=mkMc7BbWFCBv4k2fcTIkeD7TZssznShog0Cvv5PFB+E=; b=Nedd/agPgE2c81D6NK3G0qNfyBTxw0Vm3lUt4E5QOWwhROR6CML9RU3m 8Grtch8h6/XtADKykClUEwPfRYh+yat+31zhDoexe30kgFbtJTznipaR6 I86YYYs/6UJ3OlzlZd3+0HPIg+A0vGmZnhPtN9SQr4eOKUdFhvtObfC2e 4=; X-Amazon-filename: v1-0001-Fix-ordering-of-GRANTs-for-databases-in-pg_dump.patch X-IronPort-AV: E=Sophos;i="5.60,419,1549929600"; d="scan'208,223";a="672147500" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-2a-6e2fc477.us-west-2.amazon.com) ([10.47.22.38]) by smtp-border-fw-out-9102.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 01 May 2019 23:28:06 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-2a-6e2fc477.us-west-2.amazon.com (8.14.7/8.14.7) with ESMTP id x41NS6hC075267 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL) for ; Wed, 1 May 2019 23:28:06 GMT Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Wed, 1 May 2019 23:28:05 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Wed, 1 May 2019 23:28:04 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1367.000; Wed, 1 May 2019 23:28:04 +0000 From: "Bossart, Nathan" To: "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #15788: 'pg_dump --create' orders database GRANTs incorrectly Thread-Topic: BUG #15788: 'pg_dump --create' orders database GRANTs incorrectly Thread-Index: AQHVAHT+nVCsgocVwki9GG6qGkMxlaZWdMkA Date: Wed, 1 May 2019 23:28:03 +0000 Message-ID: <9C9271CF-9A7A-45AE-B034-1246A93788C9@amazon.com> References: <15788-4e18847520ebcc75@postgresql.org> In-Reply-To: <15788-4e18847520ebcc75@postgresql.org> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.160.48] Content-Type: multipart/mixed; boundary="_002_9C9271CF9A7A45AEB0341246A93788C9amazoncom_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_002_9C9271CF9A7A45AEB0341246A93788C9amazoncom_ Content-Type: text/plain; charset="utf-8" Content-ID: <248DA29ED98A8C4A88B92664A7737F83@amazon.com> Content-Transfer-Encoding: base64 SXQgbG9va3MgbGlrZSB0aGUgYnVnIHJlcG9ydGluZyBmb3JtIGRlc3Ryb3llZCB0aGUgcGF0Y2gu ICBJJ3ZlDQphdHRhY2hlZCBpdCBhZ2FpbiBoZXJlLg0KDQpOYXRoYW4NCg0KDQo= --_002_9C9271CF9A7A45AEB0341246A93788C9amazoncom_ Content-Type: application/octet-stream; name="v1-0001-Fix-ordering-of-GRANTs-for-databases-in-pg_dump.patch" Content-Description: v1-0001-Fix-ordering-of-GRANTs-for-databases-in-pg_dump.patch Content-Disposition: attachment; filename="v1-0001-Fix-ordering-of-GRANTs-for-databases-in-pg_dump.patch"; size=2068; creation-date="Wed, 01 May 2019 23:28:03 GMT"; modification-date="Wed, 01 May 2019 23:28:03 GMT" Content-ID: <125FE6213940374E86E7ED10BA679DF3@amazon.com> Content-Transfer-Encoding: base64 RnJvbSA3MTA2NDdjNTQxNTE0ZGVkMzlhZGJjOGIxMDBiNTNkMGEwMzc4NDA3IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBOYXRoYW4gQm9zc2FydCA8Ym9zc2FydG5AYW1hem9uLmNvbT4K RGF0ZTogV2VkLCAxIE1heSAyMDE5IDIzOjA0OjA0ICswMDAwClN1YmplY3Q6IFtQQVRDSCB2MSAx LzFdIEZpeCBvcmRlcmluZyBvZiBHUkFOVHMgZm9yIGRhdGFiYXNlcyBpbiBwZ19kdW1wLgoKLS0t CiBzcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5jIHwgMjIgKysrKysrKysrKysrKysrKy0tLS0tLQog MSBmaWxlIGNoYW5nZWQsIDE2IGluc2VydGlvbnMoKyksIDYgZGVsZXRpb25zKC0pCgpkaWZmIC0t Z2l0IGEvc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuYyBiL3NyYy9iaW4vcGdfZHVtcC9wZ19kdW1w LmMKaW5kZXggZGI4Y2E0MGE3OC4uMjhlNzg3NTZhOCAxMDA2NDQKLS0tIGEvc3JjL2Jpbi9wZ19k dW1wL3BnX2R1bXAuYworKysgYi9zcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5jCkBAIC0yNjcyLDEz ICsyNjcyLDIzIEBAIGR1bXBEYXRhYmFzZShBcmNoaXZlICpmb3V0KQogCQkJCQkJICAiKCVzIGRh dGRiYSkgQVMgZGJhLCAiCiAJCQkJCQkgICJwZ19lbmNvZGluZ190b19jaGFyKGVuY29kaW5nKSBB UyBlbmNvZGluZywgIgogCQkJCQkJICAiZGF0Y29sbGF0ZSwgZGF0Y3R5cGUsIGRhdGZyb3plbnhp ZCwgZGF0bWlubXhpZCwgIgotCQkJCQkJICAiKFNFTEVDVCBhcnJheV9hZ2coYWNsIE9SREVSIEJZ IGFjbDo6dGV4dCBDT0xMQVRFIFwiQ1wiKSBGUk9NICggIgotCQkJCQkJICAiICBTRUxFQ1QgdW5u ZXN0KGNvYWxlc2NlKGRhdGFjbCxhY2xkZWZhdWx0KCdkJyxkYXRkYmEpKSkgQVMgYWNsICIKLQkJ CQkJCSAgIiAgRVhDRVBUIFNFTEVDVCB1bm5lc3QoYWNsZGVmYXVsdCgnZCcsZGF0ZGJhKSkpIGFz IGRhdGFjbHMpIgorCQkJCQkJICAiKFNFTEVDVCBhcnJheV9hZ2coYWNsIE9SREVSIEJZIHJvd19u KSBGUk9NICIKKwkJCQkJCSAgIihTRUxFQ1QgYWNsLCByb3dfbiBGUk9NICIKKwkJCQkJCSAgInVu bmVzdChjb2FsZXNjZShkYXRhY2wsYWNsZGVmYXVsdCgnZCcsZGF0ZGJhKSkpICIKKwkJCQkJCSAg IldJVEggT1JESU5BTElUWSBBUyBwZXJtKGFjbCxyb3dfbikgIgorCQkJCQkJICAiV0hFUkUgTk9U IEVYSVNUUyAoICIKKwkJCQkJCSAgIlNFTEVDVCAxIEZST00gIgorCQkJCQkJICAidW5uZXN0KGFj bGRlZmF1bHQoJ2QnLGRhdGRiYSkpICIKKwkJCQkJCSAgIkFTIGluaXQoaW5pdF9hY2wpIFdIRVJF IGFjbCA9IGluaXRfYWNsKSkgYXMgZGF0YWNscykiCiAJCQkJCQkgICIgQVMgZGF0YWNsLCAiCi0J CQkJCQkgICIoU0VMRUNUIGFycmF5X2FnZyhhY2wgT1JERVIgQlkgYWNsOjp0ZXh0IENPTExBVEUg XCJDXCIpIEZST00gKCAiCi0JCQkJCQkgICIgIFNFTEVDVCB1bm5lc3QoYWNsZGVmYXVsdCgnZCcs ZGF0ZGJhKSkgQVMgYWNsICIKLQkJCQkJCSAgIiAgRVhDRVBUIFNFTEVDVCB1bm5lc3QoY29hbGVz Y2UoZGF0YWNsLGFjbGRlZmF1bHQoJ2QnLGRhdGRiYSkpKSkgYXMgcmRhdGFjbHMpIgorCQkJCQkJ ICAiKFNFTEVDVCBhcnJheV9hZ2coYWNsIE9SREVSIEJZIHJvd19uKSBGUk9NICIKKwkJCQkJCSAg IihTRUxFQ1QgYWNsLCByb3dfbiBGUk9NICIKKwkJCQkJCSAgInVubmVzdChhY2xkZWZhdWx0KCdk JyxkYXRkYmEpKSAiCisJCQkJCQkgICJXSVRIIE9SRElOQUxJVFkgQVMgaW5pdHAoYWNsLHJvd19u KSAiCisJCQkJCQkgICJXSEVSRSBOT1QgRVhJU1RTICggIgorCQkJCQkJICAiU0VMRUNUIDEgRlJP TSAiCisJCQkJCQkgICJ1bm5lc3QoY29hbGVzY2UoZGF0YWNsLGFjbGRlZmF1bHQoJ2QnLGRhdGRi YSkpKSAiCisJCQkJCQkgICJBUyBwZXJtcChvcmlnX2FjbCkgV0hFUkUgYWNsID0gb3JpZ19hY2wp KSBhcyByZGF0YWNscykiCiAJCQkJCQkgICIgQVMgcmRhdGFjbCwgIgogCQkJCQkJICAiZGF0aXN0 ZW1wbGF0ZSwgZGF0Y29ubmxpbWl0LCAiCiAJCQkJCQkgICIoU0VMRUNUIHNwY25hbWUgRlJPTSBw Z190YWJsZXNwYWNlIHQgV0hFUkUgdC5vaWQgPSBkYXR0YWJsZXNwYWNlKSBBUyB0YWJsZXNwYWNl LCAiCi0tIAoyLjE2LjUKCg== --_002_9C9271CF9A7A45AEB0341246A93788C9amazoncom_--