Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-general-owner+M228745=pgsql-general-arkari@postgresql.org>)
	id 1cdBjY-0000QE-1D
	for pgsql-general@arkaria.postgresql.org; Mon, 13 Feb 2017 08:11:40 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-general-owner+M228745=pgsql-general-arkari@postgresql.org>)
	id 1cdBjW-00023R-J7
	for pgsql-general@arkaria.postgresql.org; Mon, 13 Feb 2017 08:11:38 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <ftm.van.vugt@foxi.nl>)
	id 1cdBhB-0007qw-P6
	for pgsql-general@postgresql.org; Mon, 13 Feb 2017 08:09:13 +0000
Received: from d96425fa.static.ziggozakelijk.nl ([217.100.37.250]
 helo=storagefox.foxi.nl)
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <ftm.van.vugt@foxi.nl>)
	id 1cdBh9-0003Tp-AJ
	for pgsql-general@postgresql.org; Mon, 13 Feb 2017 08:09:12 +0000
Received: from techfox.localnet (techfox.foxi [192.168.0.31])
	by storagefox.foxi.nl (8.14.9/8.14.9) with ESMTP id v1D896V7016302;
	Mon, 13 Feb 2017 09:09:06 +0100
From: Frank van Vugt <ftm.van.vugt@foxi.nl>
To: pgsql-general@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Stephen Frost <sfrost@snowman.net>,
        Adrian Klaver <adrian.klaver@aklaver.com>
Subject: Re: intentional or oversight? pg_dump -c does not restore default
 priviliges on schema public
Date: Mon, 13 Feb 2017 09:09:06 +0100
Message-ID: <23252987.YLsmlhlehZ@techfox>
Organization: Foxi Group
User-Agent: KMail/4.14.10 (Linux/3.16.7-53-desktop; KDE/4.14.9; x86_64; ; )
In-Reply-To: <3026.1486855735@sss.pgh.pa.us>
References: <3534542.o3cNaKiDID@techfox>
 <20170211220617.GG9812@tamriel.snowman.net> <3026.1486855735@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="us-ascii"
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

Hi Tom/Stephen/Adrian,

Op zaterdag 11 februari 2017 15:28:55 schreef Tom Lane:
> I'm inclined to argue that it was a mistake to include any non-pinned
> objects in pg_init_privs.
<cut>
> We might need to fix pg_dump too, but I think these entries in
> pg_init_privs should simply not be there.

Thanks for picking this up, I'll probably see this subject pop up on hackers 
and/or committers at some point ;)

Allow me to emphasize that this issue basically means that for v9.6 after 
restoring a dump created with the '-c' option one ends up in a situation that 
might be quite confusing for users that didn't have to pay much attention yet 
to handling priviliges... i.e. trying even a plain select on table_a in the 
public schema as a non-system user returns something like:
	ERROR:  relation "table_a" does not exist



-- 

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