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 1kn5d4-0005Hv-4h for pgsql-admin@arkaria.postgresql.org; Wed, 09 Dec 2020 20:00:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kn5d2-0002If-Vp for pgsql-admin@arkaria.postgresql.org; Wed, 09 Dec 2020 20:00:00 +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 1kn5d2-0002IY-OE for pgsql-admin@lists.postgresql.org; Wed, 09 Dec 2020 20:00:00 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kn5cy-0003Aa-C2 for pgsql-admin@lists.postgresql.org; Wed, 09 Dec 2020 20:00:00 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id EC75B5F799; Wed, 9 Dec 2020 14:59:54 -0500 (EST) Date: Wed, 9 Dec 2020 14:59:54 -0500 From: Stephen Frost To: Scott Ribe Cc: Tom Lane , Pgsql-admin Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate Message-ID: <20201209195954.GF16415@tamriel.snowman.net> References: <074FE83A-E924-4787-9E68-27EB9CE142B3@elevated-dev.com> <3264512.1607456932@sss.pgh.pa.us> <154608A6-0F38-4BE8-B3F4-3E3308691F91@elevated-dev.com> <2BD26D52-19B8-42CD-860D-B9AE21AF5C61@elevated-dev.com> <3632844.1607534358@sss.pgh.pa.us> <68634B7E-3AD0-42A3-9A2D-EC3988E755E4@elevated-dev.com> <20201209184925.GA16415@tamriel.snowman.net> <20201209192406.GD16415@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="DVvfuLztJmLFvBNc" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --DVvfuLztJmLFvBNc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Scott Ribe (scott_ribe@elevated-dev.com) wrote: > > On Dec 9, 2020, at 12:24 PM, Stephen Frost wrote: > >=20 > > Are you sure you have privileges to perform the REVOKE and that it > > actually did something..? Check the results in psql using: >=20 > no errors, and your example exactly matches what I see there Well, pg_dump here doesn't emit any GRANT commands for that table when run and the table has those privileges, so something doesn't add up. Are you sure you're looking at the right database? Do you see GRANT or REVOKE commands for that table when you run pg_dump by hand..? Thanks, Stephen --DVvfuLztJmLFvBNc Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJf0Sy6AAoJEO1sijiDR2RVScIP/RmujEtMboDxdebgiReWM1xu rJXkPU5CVwaE5V58D3d+FuAXsaA9+e/ZqHvLqaNSpAQWUMkPurjWSm/6wBuUQK3z 9TX/n2C35lRSFR9BtSFW3qJuLr2rO5t1NG5zlIdJ9/DaZSH+82X+oQTnPrc+cFUO ECwELGHitG/koiPLALawdbQzx56tkWvz+aFQm+1hZRpUZC3S04pZGaUM0mytvCDm x9J5rPWgJHmZ04XMYpZD+PxOOiUeB38S0p5LgfmM22SWzh3azSfU9HLSrG3gDWDY vAb238c+lzQ/NlkyafQXt5+o5F5CxKOPSDPgxXS0g0JpI9yKAlm78oaNuOst7fOb JY8pDJixK7OWB3d7Wtr3BZttvDMFhde+oPdRH4uYgDYnc/Rgr6MlbMdfpngi8agO 2GrepTYhmZTaPzLkFAbb3CIe2syF4E5dqE0C5McvNZ1t+K/7WAJiYlHdf/PLPhRw UOGEKZhSgv3Nn5EzE0H839TQKJdBk5prLVXzQYiYxeSChwIGc0/Ef00fL2TeQtvv KY2/OnV9j3hmPUbytawtA68Urcqckmo0l5cpt8ap45mJL6RLRHae80WCTC2y/1tG b7IkU/IRnMRu82WOerM+V+vchdHSbJSBnJ1080mgMOo2fm9ThKa6ud7+nc3fKvhD n4R3iXVWzfURo6s3fxIK =swsy -----END PGP SIGNATURE----- --DVvfuLztJmLFvBNc--