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

From Peter Eisentraut
Subject Re: [HACKERS] PUBLICATIONS and pg_dump
Date
Msg-id 9314263d-f331-3ef0-a127-0c475f133914@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] PUBLICATIONS and pg_dump  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [HACKERS] PUBLICATIONS and pg_dump  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
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.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [HACKERS] Idea on how to simplify comparing two sets
Next
From: Stephen Frost
Date:
Subject: Re: [HACKERS] PUBLICATIONS and pg_dump