Re: Issue on public schéma with Pg_restore - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Issue on public schéma with Pg_restore
Date
Msg-id 53ffe598-eb73-0ed1-36db-057b7ca0572c@aklaver.com
Whole thread Raw
In response to Issue on public schéma with Pg_restore  (Thomas Poty <thomas.poty@gmail.com>)
Responses Re: Issue on public schéma with Pg_restore
List pgsql-general
On 04/25/2018 11:07 AM, Thomas Poty wrote:
> Hello,
>   Here is the context :

Postgres version?

> I have a db db1 with a schéma public on cluster C1.
> This schéma doesn't have any privileges on public role.
> I have a dump of this db.

What was the dump command?

> On an other cluster C2, the template1 doesn't contain schema public.
> I have restored db1  on cluster C2 and i saw public role had the 
> privilege create on the schéma public.

What was the restore command?

> 
> I cannot explain this
> 
> Thank you.
> 
> Thomas?
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Thomas Poty
Date:
Subject: Issue on public schéma with Pg_restore
Next
From: Vincent Veyron
Date:
Subject: Re: Same condition in the CTE and in the subsequent JOIN using it