Feike Steenbergen wrote:
> On 23 October 2017 at 14:54, Alvaro Herrera <alvherre@2ndquadrant.com>
> wrote:
> >
> > Reinier Haasjes wrote:
> > > Hi,
> > >
> > > I noticed that pg_dump since 9.6 is missing some default privileges
> > Hmm, I can confirm that 9.6 seems to have this problem while 9.5 does
> > not seem to have it. Must have been broken at some point during the
> > extensive pg_dump patches in 9.6 ... I'll give this a look.
>
> in buildACLQueries there is a filter to exclude those acl's that match the
> pg_init_privs or default pg_catalog.acldefault for that role.
Ah, thanks, Feike.
So what is going on is that those commands don't actually have any
visible effect in pg_dump because they change the privileges from the
default state to a state that's identical to the default. I suppose
that makes sense.
However, I don't think Reinier would have gone to the trouble of
reporting the problem unless there was something actually being affected
by it. Am I mistaken?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs