pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
Date: Wed, 9 Dec 2020 14:59:54 -0500
Message-ID: <20201209195954.GF16415@tamriel.snowman.net> (raw)
In-Reply-To: <F2A313AD-7C0F-43E8-9D60-6A6515409E3D@elevated-dev.com>
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>
	<B292176F-B507-498F-975B-3548D73A8352@elevated-dev.com>
	<20201209192406.GD16415@tamriel.snowman.net>
	<F2A313AD-7C0F-43E8-9D60-6A6515409E3D@elevated-dev.com>

Greetings,

* Scott Ribe (scott_ribe@elevated-dev.com) wrote:
> > On Dec 9, 2020, at 12:24 PM, Stephen Frost <sfrost@snowman.net> wrote:
> > 
> > Are you sure you have privileges to perform the REVOKE and that it
> > actually did something..?  Check the results in psql using:
> 
> 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

Attachments:

  signature.asc (application/pgp-signature, 818B) download

view thread (25+ messages)  latest in thread

Message-ID: <20201209195954.GF16415@tamriel.snowman.net>
Permalink:  ../20201209195954.GF16415@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20201209195954.GF16415@tamriel.snowman.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sfrost@snowman.net, scott_ribe@elevated-dev.com, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
  Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
  In-Reply-To: <20201209195954.GF16415@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox