Re: [GENERAL] missing public on schema public

I have some additional info and a fix.

Firstly steps to reproduce:

1.  create database:

CREATE DATABASE test WITH ENCODING='UTF8' OWNER=postgres CONNECTION LIMIT=-1;

-- here public has access to public

2. dump:

pg_dump -f testfile.dump -F c -h localhost -U postgres test

3. restore:

pg_restore -c -d testfile.dump -h localhost -U postgres test

-- here public no longer has access to schema public

It is easily fixable with:

GRANT ALL ON SCHEMA public TO public;

And the issue goes away.. (privilege stays after next dump/restore)

So. What am I missing?

Is this intentional functionality ?

Kind regards and again thank you for your time

Bo Thorbjørn Jensen