Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Date: 2017-03-07 14:32:45
Message-ID: 20170307143245.GI9812@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Stephen Frost (sfrost(at)snowman(dot)net) wrote:
> * Frank van Vugt (ftm(dot)van(dot)vugt(at)foxi(dot)nl) wrote:
> > Well, I didn't run into this issue with any of my db's that 'nicely' use
> > tables in various schema's, it was actually the one 'older' db with everything
> > in the public schema that brought it up, so maybe keeping one of those around
> > isn't too bad an idea ;)
>
> Yeah, I'll be including this in a regression test also, to make sure we
> don't end up breaking this special case again in the future.

I've now pushed a fix for this, would be great to know if it solves your
issue.

Thanks!

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-03-07 15:04:25 Re: is (not) distinct from
Previous Message Vick Khera 2017-03-07 13:02:40 Re: Copy database to another host without data from specific tables