Home > mailing lists

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

From	Thomas Poty
Subject	Issue on public schéma with Pg_restore
Date	April 25, 2018 21:07:30
Msg-id	CAN_ctnjgjCvAM+L4ZTg+sh6wGVMAzjZwR9m1_4vMVKSTB7n-FA@mail.gmail.com Whole thread Raw
Responses	Re: Issue on public schéma with Pg_restore
List	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?

From: Andreas Kretschmer
Date: 25 April 2018, 20:36:41
Subject: Re: Same condition in the CTE and in the subsequent JOIN using it

From: Adrian Klaver
Date: 25 April 2018, 21:24:21
Subject: Re: Issue on public schéma with Pg_restore