Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump needs SELECT privileges on irrelevant extension table - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: pg_dump needs SELECT privileges on irrelevant extension table
Date
Msg-id CAGu=u8jcD1DuazVmo9JoLe9jEwp7WnVncUEiagNaG-tpKEZ5uw@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump needs SELECT privileges on irrelevant extension table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump needs SELECT privileges on irrelevant extension table
List pgsql-hackers
Tree view 
On Wed, Oct 18, 2023 at 1:25 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > This change would mean that policies added by a user after the extension
> > is created would just be lost by a pg_dump/reload, doesn't it?
>
> Yes.  But I'd say that's unsupported, just like making other ad-hoc
> changes to extension objects is unsupported (and the effects will be
> lost on dump/reload).  We specifically have support for user-added
> ACLs, and that's good, but don't claim that we have support for
> doing the same with policies.

Is this approach backportable?

(Adding Aleks to CC -- Timescale may want to double-check that the new
proposal still works for them.)

Thanks,
--Jacob

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Show version of OpenSSL in ./configure output
Next
From: Isaac Morland
Date:
Subject: Re: PostgreSQL domains and NOT NULL constraint