Issue on public schéma with Pg_restore

From: Thomas Poty <thomas(dot)poty(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Issue on public schéma with Pg_restore
Date: 2018-04-25 18:07:30
Message-ID: CAN_ctnjgjCvAM+L4ZTg+sh6wGVMAzjZwR9m1_4vMVKSTB7n-FA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
Here is the context :
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.
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.

I cannot explain this

Thank you.

Thomas?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-04-25 18:24:21 Re: Issue on public schéma with Pg_restore
Previous Message Andreas Kretschmer 2018-04-25 17:36:41 Re: Same condition in the CTE and in the subsequent JOIN using it