Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] missing public on schema public - Mailing list pgsql-general

From Bo Thorbjørn Jensen
Subject [GENERAL] missing public on schema public
Date
Msg-id AD7252BEFBCA3846A8D34ABCDA258D080120F01B0B@EXMBX05.mailcloud.dk
Whole thread Raw
List pgsql-general
Tree view

Hi

 

We recently upgraded from 9.1 to 9.6 (now 9.6.6) and have, after dump/restore on 9.6, experienced the loss of public priviliges on schema public.

 

Is this a “feature” or some kind of bug ?

 

I have found a thread here that looks sortof similar with subject: “[GENERAL] intentional or oversight? pg_dump -c does not restore default priviliges on schema public”

But it is from march 2017 and it looks like it ends with a fix being pushed..

 

Version() is

"PostgreSQL 9.6.6, compiled by Visual C++ build 1800, 64-bit"

Binary from EDB

 

Thank you for your time.

 

Kind regards

 

Bo Thorbjørn Jensen

Udvikler hos budget123

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: [GENERAL] sync the data's from catalog table
Next
From: Dinesh kumar
Date:
Subject: Re: [GENERAL] sync the data's from catalog table