missing public on schema public

From: Bo Thorbjørn Jensen <bo(at)budget123(dot)dk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: missing public on schema public
Date: 2017-11-13 09:45:56
Message-ID: AD7252BEFBCA3846A8D34ABCDA258D080120F01B0B@EXMBX05.mailcloud.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Dinesh kumar 2017-11-13 10:11:02 Re: sync the data's from catalog table
Previous Message Laurenz Albe 2017-11-13 08:42:59 Re: sync the data's from catalog table