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 1hMtqD-0001Js-4x for pgsql-bugs@arkaria.postgresql.org; Sat, 04 May 2019 12:32:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hMtqC-0008FJ-0w for pgsql-bugs@arkaria.postgresql.org; Sat, 04 May 2019 12:32:32 +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 1hMtqB-0008FC-Pl for pgsql-bugs@lists.postgresql.org; Sat, 04 May 2019 12:32:31 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hMtq8-0001nb-Ls for pgsql-bugs@lists.postgresql.org; Sat, 04 May 2019 12:32:31 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 50488210DB; Sat, 4 May 2019 08:32:26 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sat, 04 May 2019 08:32:26 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=vbliEwdXRcPKNH3i1+I/5QORbjk BmBGcVFL57v6B2Zo=; b=hIvjMq0Rp+FARmu0XVf3bZMRycjo4VhMLQ9wCmYYlRl nz+I+3PsLe2Zfqt/2goWiMDf+YdhQFHH+zXhSKzTCTC6MNLiWkCFtnOZHmUmfRQC 7ENjQnC52c61xmQYrl372SUmCMbPLagmCjiOusSKd30i/UXdXUm3PgEh/9rzes26 b8J+Di9vmXIfIiVCLUz4tDD53rNTEvOm/6ggpCvO73m9+6ZUM4qqE41qAoQ0w26q H7W812NDe5kBAdp6ojj3KRX9BEVHiGA1yWMJdZ6QpYQq6aP91ZI0gKaFkLRKK+vn 8ufEFdRWMLKW4Avb3GFTE22xAg86D1W5T3LeYNpQLeQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=vbliEw dXRcPKNH3i1+I/5QORbjkBmBGcVFL57v6B2Zo=; b=CI1AXwbr6AdKcNJo+dVHJ1 p3M7pk45MzXTu92CAAdB03UHsmUhBrvCLVbH3gs4KdHts2INqiMRyFWtwLgewoL2 Ncd+CXCTekt4iR/AB/Sguna3EH6taG3/SE2vtLiuzC3PLhBlArpCtTr8l3TdkZZ7 tDQkypheOia6XNqk8a/xKTxO+cuIpxsSHvzchkWjF3TketmZZRN8VdIU+U/P3iGS FofK7LtoBoK35XFpapyHRYlpU+KWZ+/UbLU7nRRbYu4rvTk0khyujkbPEH1jSOv2 ryJZ9PpdwlAyJ3rUCgAxl2j3X9EzjXo1e7xqHMSpDLOkb3xLPPqvKFst2A6qvZUQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddrjeefgdehfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfk phepudduuddruddtvddrudektddrudekheenucfrrghrrghmpehmrghilhhfrhhomhepmh hitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id AC5B51037C; Sat, 4 May 2019 08:32:24 -0400 (EDT) Date: Sat, 4 May 2019 21:32:21 +0900 From: Michael Paquier To: "Bossart, Nathan" Cc: Haribabu Kommi , "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #15788: 'pg_dump --create' orders database GRANTs incorrectly Message-ID: <20190504123221.GA2127@paquier.xyz> References: <15788-4e18847520ebcc75@postgresql.org> <9C9271CF-9A7A-45AE-B034-1246A93788C9@amazon.com> <4D066CB2-B177-40B4-8510-9318B9A184CE@amazon.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ZPt4rx8FFjLCG7dd" Content-Disposition: inline In-Reply-To: <4D066CB2-B177-40B4-8510-9318B9A184CE@amazon.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --ZPt4rx8FFjLCG7dd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, May 03, 2019 at 05:22:47PM +0000, Bossart, Nathan wrote: > Thanks for taking a look. I've attached all the versions of the patch > needed to back-patch this down to 9.6, where this query was > introduced. This requires a careful lookup, and it may be too late for the next round of minor releases. Could you add it to the next commit fest [1] so as we don't forget about it? [1]: https://commitfest.postgresql.org/23/ -- Michael --ZPt4rx8FFjLCG7dd Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlzNhlUACgkQnvQgOdby QH1R3hAAohZ1yxUay/DO7FBIkGn8ghobbtjg9jVHa8lBXeHC/40W1hSFEaAxO8rc vy5YXQGlkBiP1potROeHYHO6coQL3r3lXkPAOdPypaTHYIsIli/6KrT2i0Lq7aPq IpAGv7Txe0G3m7lWSdiNaO0o9r4iEVIPU5Xy/+IHAF5k7uC4TEo+Eq1PuW2gsylB hIUN3fKKkEw/zgheOlFxnYqvo2YR8zTw45GsrmQAPBhjOhZ6qbEI0nkWGNpzLjdq sb7dWEnnf7CY1umv8ilUJ/w8Ri3AgJzdoLqcewyEPc+cAPmTumyefbYAHmbbKUNz l/v59hUlCz3btJWWcZ80L1LieIn0mKqEywq4e6gQy+cqjxKzEoaEpQN2glFDy7v9 UcfvTA3yn06YjOtjYUDt23zfVrylurI5OZKkb5t1PWHTD5320w4R7aQNAS5XyqRL bdyAIW6BfhAWAxpzM0qzxY4/ph3uQDtd8YiP7PmCNE/ZXsZ3DQ/bK+HC6hg44R/2 qIFzhFIemSr3I+QZ+nKTEaI95bgr3mphGK3tfjPcRYhjWoi2BjDpBvidn5HWlz/F kiu/D5Sc9jZFJJJWGhoxQaj9zOgIEqZvrIgaG3nN3e+19U0xlJBk2EWB1twBvGCs 8VctnU96292OhnZIyQkdrVlCz11d7/eu843R1qMp4z8kXWekpHM= =AR5b -----END PGP SIGNATURE----- --ZPt4rx8FFjLCG7dd--