From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Feike Steenbergen <feikesteenbergen(at)gmail(dot)com> |
Cc: | Reinier Haasjes <Reinier(dot)Haasjes(at)adyen(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: [pg_dump] not dumping some default privileges |
Date: | 2017-10-23 14:03:57 |
Message-ID: | 20171023140357.6rufr5o7wnjmbew6@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Feike Steenbergen wrote:
> On 23 October 2017 at 14:54, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-10-23 14:09:22 | Re: BUG #14866: The generated constraint in the typed table causes the server to crash |
Previous Message | Michael Paquier | 2017-10-23 13:50:24 | Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much |