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 1kn4ln-0003Ad-0N for pgsql-admin@arkaria.postgresql.org; Wed, 09 Dec 2020 19:04:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kn4ll-0005rR-Vl for pgsql-admin@arkaria.postgresql.org; Wed, 09 Dec 2020 19:04:57 +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 1kn4ll-0005rK-OW for pgsql-admin@lists.postgresql.org; Wed, 09 Dec 2020 19:04:57 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kn4lj-0002QJ-Oc for pgsql-admin@lists.postgresql.org; Wed, 09 Dec 2020 19:04:57 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id F30A85F799; Wed, 9 Dec 2020 14:04:54 -0500 (EST) Date: Wed, 9 Dec 2020 14:04:54 -0500 From: Stephen Frost To: Tom Lane Cc: Scott Ribe , Pgsql-admin Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate Message-ID: <20201209190454.GB16415@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> <3674534.1607540538@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="FH2t87iiyOa1qHK5" Content-Disposition: inline In-Reply-To: <3674534.1607540538@sss.pgh.pa.us> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --FH2t87iiyOa1qHK5 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Tom Lane (tgl@sss.pgh.pa.us) wrote: > Stephen Frost writes: > > (I'm generally not a fan of hacking around in the catalog tables > > directly...) >=20 > I'd avoid that too, except he's about to migrate off the instance > entirely, so fine points like whether dependencies are up-to-date > shouldn't cause too much problem. A REVOKE of the privilege shouldn't cause any issues either and avoids hacking on the catalog. It's also simpler to un-do should they need to revert to the old system for whatever reason, and avoids making people feel comfortable with modifying the catalog tables directly. Thanks, Stephen --FH2t87iiyOa1qHK5 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJf0R/WAAoJEO1sijiDR2RVLKIP/RUHqMycqJK0vISD36xVsC5E Zk13vhIFK43I4wCJIpLKQvErhH0I0OsDdu+qCIFo8qFgoLaauzXc2z/1C50YPgsC Ge7FXS4trKkGHLKmty1vwxyW8f26XxixJkKBCQ0NTjm1ooEES+67l1doBid23r/5 P/ywWBbAKYyN7tKt+8wo64t2guohIJjHTeeKSyCwIsWlJuxg2tN9F7d7BEoBQeeq tGWSx2YJN+r8c3ArypSxtcbWDBkPlVQkrMbodjaVqeKXWxFJP9L7ZEsWZaswDTXn nhQ0bScpCNaL171ez/vvjZxD/r30cdeg4SBgPPJ1nTyuqt+W/vQJTgLec5f7NHEP yE6L0eV6vdaCIxoBiEOZphuB7k5EBArqje+rNL35veOfLh0Vn/pEtEs9pRSx9Q/P /UB6lOgV1Kzl48q8NM5mk2EF1J3QekM/WJK4iCaabdpf0lhIeeIBNBXNYzTx0b+/ Zq5gkmEePisXwW8oM/ENVTGBc3FWiTmFZkGeCF8EbHL3s7oYcO9IlzhakIrC3iZm H4lYZRfSSePfjLeoWHXd12VdLorMz7OXLRLsF05Va9Z3x9gI4c88r2/Kx2qbLkaO leXFo8QcT8HO31ZhrkDxJxymJgFa0ZuVhkdte+ZjZ3PNhUZJrdA1+TXsogNZnqQ8 9nxNUMo+ba/CQhKFw2aw =hcxW -----END PGP SIGNATURE----- --FH2t87iiyOa1qHK5--