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 1hTUay-0003EH-Sm for pgsql-bugs@arkaria.postgresql.org; Wed, 22 May 2019 17:00:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hTUax-0003SV-IO for pgsql-bugs@arkaria.postgresql.org; Wed, 22 May 2019 17:00:03 +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 1hTUax-0003SO-8Y for pgsql-bugs@lists.postgresql.org; Wed, 22 May 2019 17:00:03 +0000 Received: from smtp-fw-33001.amazon.com ([207.171.190.10]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hTUau-0007pf-SL for pgsql-bugs@lists.postgresql.org; Wed, 22 May 2019 17:00:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1558544400; x=1590080400; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=wL8efz0VM9YKpzdOKe+e/84xnNPmZdq3GE1t82fWGh4=; b=XL4BuMdrG6loRRgWNwegRsELxKcn68NkIag9QaFNZCwvSE7e9Izv0Flq dmGIh3DmRGIcPgdUIGr6/HOieT0XqRAxNR6sfT9nBR3/YSG3emRDtIzOJ ECl1H7t5EingBk76CVoDxTSeBMI0nF7q/xt6hEPpG8y7seKPm0NCpBUUf U=; X-IronPort-AV: E=Sophos;i="5.60,499,1549929600"; d="scan'208";a="801179751" Received: from sea3-co-svc-lb6-vlan2.sea.amazon.com (HELO email-inbound-relay-1e-303d0b0e.us-east-1.amazon.com) ([10.47.22.34]) by smtp-border-fw-out-33001.sea14.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 22 May 2019 16:59:55 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad55-ws-svc-p15-lb9-vlan3.iad.amazon.com [10.40.159.166]) by email-inbound-relay-1e-303d0b0e.us-east-1.amazon.com (8.14.7/8.14.7) with ESMTP id x4MGxr8E077060 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Wed, 22 May 2019 16:59:55 GMT Received: from EX13D03UWC001.ant.amazon.com (10.43.162.136) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Wed, 22 May 2019 16:59:54 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC001.ant.amazon.com (10.43.162.136) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Wed, 22 May 2019 16:59:54 +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, 22 May 2019 16:59:54 +0000 From: "Bossart, Nathan" To: Michael Paquier CC: Haribabu Kommi , "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+nVCsgocVwki9GG6qGkMxlaZWdMkAgADD1oCAAfrFgIABtoiAgALryYCAFfT9gIAAeFoAgAKKmgCAADujgA== Date: Wed, 22 May 2019 16:59:53 +0000 Message-ID: <1FE3AB7F-0AF9-4F38-B41D-51F219509281@amazon.com> References: <15788-4e18847520ebcc75@postgresql.org> <9C9271CF-9A7A-45AE-B034-1246A93788C9@amazon.com> <4D066CB2-B177-40B4-8510-9318B9A184CE@amazon.com> <20190504123221.GA2127@paquier.xyz> <0AF6E4BC-EE9A-4158-85BE-3EAE4308D228@amazon.com> <20190520082705.GA1921@paquier.xyz> <92E61F31-BD06-49B1-950F-8863239E342F@amazon.com> <20190522062626.GC1486@paquier.xyz> In-Reply-To: <20190522062626.GC1486@paquier.xyz> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.161.34] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gNS8yMS8xOSwgMTE6MjYgUE0sICJNaWNoYWVsIFBhcXVpZXIiIDxtaWNoYWVsQHBhcXVpZXIu eHl6PiB3cm90ZToNCj4gT24gTW9uLCBNYXkgMjAsIDIwMTkgYXQgMTA6Mzc6NTBQTSArMDAwMCwg Qm9zc2FydCwgTmF0aGFuIHdyb3RlOg0KPj4gT24gNS8yMC8xOSwgMToyNyBBTSwgIk1pY2hhZWwg UGFxdWllciIgPG1pY2hhZWxAcGFxdWllci54eXo+IHdyb3RlOg0KPj4+IEkgaGFkIGZpcnN0IGEg aGFyZCB0aW1lIHBhcnNpbmcgdGhlIHN1YnF1ZXJpZXMgYWRkZWQsIHNvIEkgaGF2ZQ0KPj4+IHR3 ZWFrZWQgeW91ciBwYXRjaCB3aXRoIG1vcmUgaW5kZW50YXRpb24sIGFuZCBhIGNvbW1lbnQgYmxv Y2sgd2l0aA0KPj4+IG1vcmUgZGV0YWlscyBhYm91dCB3aHkgd2UgbmVlZCB0byBwcmVzZXJ2ZSB0 aGUgQUNMIG9yZGVyaW5nICh5b3Ugd2lsbA0KPj4+IG5vdGUgdGhhdCBJIGRvbid0IGhhdmUgYSBs b3Qgb2YgaW1hZ2luYXRpb24gaGVyZSkuDQo+PiANCj4+IFRoYW5rcy4gIFlvdXIgdmVyc2lvbiBs b29rcyBnb29kIHRvIG1lLg0KPg0KPiBPa2F5LCBJIGhhdmUgZG9uZSBtb3JlIHRlc3RzLCBjaGVj a3MgYW5kIHR3ZWFrcyBvbiB0aGlzIHN0dWZmLCBhbmQNCj4gcHVzaGVkIHRoZSBmaXggZm9yIGRh dGFiYXNlcyBkb3duIHRvIDkuNi4NCg0KVGhhbmtzIQ0KDQo+IFRoZSBwcm9ibGVtIGNvbWVzIGZy b20gZHVtcFRhYmxlc3BhY2VzKCkgd2hpY2ggc3RpbGwgaGFzIGEgYnJva2VuIEFDTA0KPiBvcmRl cmluZyBsb2dpYy4gIEknbGwgc3RhcnQgYSBuZXcgdGhyZWFkIGFib3V0IHRoYXQgYXMgdGhpcyB0 aHJlYWQgaXMNCj4gYWN0dWFsbHkgbm93IGZpeGVkLiAgSXQgd291bGQgYmUgaW50ZXJlc3Rpbmcg dG8gcmVmYWN0b3IgYWxsIHRoYXQNCj4gc3R1ZmYsIGJ1dCBJJ2QgbGlrZSB0byB0aGluayB0aGF0 IGl0IHdvdWxkIGJlIG11Y2ggbW9yZSBpbnRlcmVzdGluZyBpZg0KPiB3ZSBjb3VsZCBnZXQgcGdf aW5pdF9wcml2cyB0byB3b3JrIHdpdGggZGF0YWJhc2VzIGFuZCB0YWJsZXNwYWNlDQo+IGluc3Rl YWQsIGJ1dCB0aGF0IHdvdWxkIG5vdCBiZSBiYWNrLXBhdGNoYWJsZS4gIFNvIEknbGwgZm9jdXMg b24gdGhlDQo+IGJ1ZyBmaXguDQoNCkknbGwgdGFrZSBhIGxvb2sgYXQgdGhpcy4NCg0KTmF0aGFu DQoNCg==