Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQyA1-00CatV-Ri for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2024 23:52:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sQyA0-00Almz-E6 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2024 23:52:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQy9z-00Almr-Kg for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2024 23:52:44 +0000 Received: from fout8-smtp.messagingengine.com ([103.168.172.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQy9w-00176c-SS for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2024 23:52:42 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailfout.nyi.internal (Postfix) with ESMTP id CCC481380D80; Mon, 8 Jul 2024 19:52:39 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 08 Jul 2024 19:52:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1720482759; x=1720569159; bh=kM/h6FTQLJ IPQnpVWaNo576XWofMHvglWw5xC7lnQt4=; b=oJHEsUSBp2g3D7VqNWCtlEztng cRkriXEGISZEoiSIYNbpVAb/UlqactLhouzHptMbX4D0EzWh2TfP//ZL7R/CTyq+ xKt8gmMFIpg+9w36Hl5dSVoMOm1cmgCj8+wFtXlKhlWTIvqF4/YUUzFgCXWFJWpr OzFHg2kewKVDwAEXrl7BZ+LQAFZqyYdPRoHMbiBs5kbb0qpTxKLysBjR1MIdrbQ6 /+W1yo8Ikcb4yhDw7QiMrP2DUxDDC4ltdsuedKHRU5wSOHh7dLfHiq95U8gv3eL7 w55Mx1EufZEFLVeA4rvEJYd/aHDgR9sPxPajqys5GnTULU8jwwihjS6wjYHA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1720482759; x=1720569159; bh=kM/h6FTQLJIPQnpVWaNo576XWofM HvglWw5xC7lnQt4=; b=tV7Bb09SgD4dQAVaee8Phk9jkawxyiqJXGEE8cP3jEvQ 9MoJ1Ycz9nj0BUCegHjFIfVZMJ9n3q0luclKCinTTGjQMnffm2y0v9FpkhgIlet9 +iUpmDA5C8AO9TTT5+20TMkpJW0zYQkipNsYooODkW7nfjjns9tBqDGEMLbiM5js lGftjDkN0dZ5u+/Bpgs4IdqNBYcY8A5lkOdrVEE0vrbz4XSD99wL8FJVFTsApsU1 VLeWCykcBXPtZg5dcOkyxUg+eOUgdaEK29hYHPVIpfjvyijELEudyHA6tIhoqElg SDZoPfRrWGSSjNPUU0y6kpJZJQSpu406OK2oiYDsjA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvdekgddvjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeg geffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 8 Jul 2024 19:52:37 -0400 (EDT) Date: Tue, 9 Jul 2024 08:52:25 +0900 From: Michael Paquier To: Joel Jacobson Cc: Tom Lane , Postgres hackers Subject: Re: pgsql: Add pg_get_acl() to get the ACL for a database object Message-ID: References: <3408967.1720107891@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="deRP2W7QoP0Eqwvx" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --deRP2W7QoP0Eqwvx Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Jul 08, 2024 at 11:55:28AM +0200, Joel Jacobson wrote: > Patch didn't apply to HEAD nor on top of any of the previous commits eith= er, > but I couldn't figure out why based on the .rej files, strange. > I copy/pasted the parts from the patch to test it. Let me know if you nee= d a > rebased version of it, in case you will need to do the same, to save some= work. Strange. I have just downloaded v2 again. `patch -p1` and `git am` are both working here. > Also noted the below in your last commit: >=20 > a6417078c414 has introduced as project policy that new features > committed during the development cycle should use new OIDs in the > [8000,9999] range. >=20 > 4564f1cebd43 did not respect that rule, so let's renumber pg_get_acl() > to use an OID in the correct range. >=20 > Thanks for the info! > Will make sure to use the `src/include/catalog/renumber_oids.pl` tool > for future patches. No problem. This is the kind of tweaks that are really easy to forget. -- Michael --deRP2W7QoP0Eqwvx Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmaMe7kACgkQnvQgOdby QH0enw//f0R9+6tj73IqVtf7DDq+uFYZuqQe5BVSs7tBexELRsk4pvyJQVXdeWY7 +mPA+4rnr+fyXCsaMUjyyBTKRzecwBhSFAD8RYpUkkduT2LjkNnULKnrVkch6HVD mAI7LN5RVA4Hohgz2pWa7fm/iZqqsm0CEKmpE6U2lx1YtYbb36zW4i93MA0gKvWc lG8I4aTxNs1Uvrn6yUw0Xg9WCKdIOp97zWlie4DKSe1MI1XPPmYgGPa/bwiqXyiO xSZJ628p8ZaLEe1EFndhbJJbfl8TIPhd9244AifgwOSBpj6emiz268BRa0l8+m3B qt9BoXpC1l0RrJ7Aw3WTR/wr6/SFv6dLTBpVvuMfY1cTof+iSGezgX+TottpNymv GJhzZcfj9KVK2rDvlg12QBwfeZAHBnmSG1eXRVPyUei0KKXc0b18uzV5NVxAcY7r LJHAuw967+2bJiohuZU9ZuGen/mU2w9VGm7X9YwwpkAhQasMdY4XUJ4eGFmF5jGh MIdmwGygca9ETPH3eFYJaSk43Mo5YORiFUG65ZfwTEo/bYApiC8J37v7ygod+LWB fKgqiTIMESSzEE98ocfpZKrRlOna1XOA8sYWDYFDS3Zx2zyFwWgthBOU5GjPxxvN Om6RngNQIZvOGb3WFk+Xflm4T1Tmb29bd7mXBSjt8jBYwSZS/gY= =nrD5 -----END PGP SIGNATURE----- --deRP2W7QoP0Eqwvx--