Re: [HACKERS] PUBLICATIONS and pg_dump - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [HACKERS] PUBLICATIONS and pg_dump
Date
Msg-id CAOuzzgrU5jyKT2XoFyui4uFXZX-SPDg3PB=aLEqX84Zf3QgWDg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] PUBLICATIONS and pg_dump  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: [HACKERS] PUBLICATIONS and pg_dump
List pgsql-hackers
Peter,

On Tue, Feb 7, 2017 at 22:49 Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
On 2/7/17 3:19 PM, Stephen Frost wrote:
> I understand that this is a bit complicated, but I would have thought
> we'd do something similar to what is done for DEFAULT PRIVILEGES, where
> we include the "global" default privileges when we are doing a dump of
> "everything", but if we're dumping a specific schema then we only
> include the default privileges directly associated with that schema.
>
> Perhaps we need to include publications which are specific to a
> particular table, but the current logic of, essentially, "always include
> all publications" does not seem to make a lot of sense to me.

I think it would be sensible to refine it along those lines.

Great!  I've added it to the open items list for PG10. 

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] PUBLICATIONS and pg_dump
Next
From: Peter Eisentraut
Date:
Subject: [HACKERS] drop support for Python 2.3