From: Frank van Vugt <ftm.van.vugt@foxi.nl>
To: Stephen Frost <sfrost@snowman.net>
Cc: pgsql-general@postgresql.org
Subject: Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Date: Mon, 13 Feb 2017 17:55:52 +0100
Message-ID: <2623240.ZhDaCM8aGs@techfox> (raw)
In-Reply-To: <20170213141042.GJ9812@tamriel.snowman.net>
References: <3534542.o3cNaKiDID@techfox>
<23252987.YLsmlhlehZ@techfox>
<20170213141042.GJ9812@tamriel.snowman.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Hi Stephen,
Op maandag 13 februari 2017 09:10:42 schreef Stephen Frost:
> We should be able to get it addressed shortly.
Great, 'as always', I'd like to add!
Thanks for the great work, people. This cannot be stated too often...
> For your specific case
Thanks for the additional info, interesting.
> Yes, it's unfortunate that many users aren't really familiar with
> schema-level privileges.
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 ;)
--
Best,
Frank.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: ftm.van.vugt@foxi.nl, sfrost@snowman.net
Subject: Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public
In-Reply-To: <2623240.ZhDaCM8aGs@techfox>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox