remove public schema from OBF

[rfbrown]

The following errors occur when running OBF on setup:

ERROR: schema "public" already exists ALTER SCHEMA ERROR: must be owner of schema public

I confirmed that the public schema is created automatically, with postgres as the owner on Ubuntu 20.04, PostgreSQL 15.2. Removing the relevant lines from OBF resolves the issue in my case.

I suggest (a) lines 77-95 be removed from OBF, or (b) the script be modified with some checks prior to executing the relevant statements.

I was going to do a pull request with line removal fix, but the contributing guidelines scared me away...

[atn38]

Hi Renee, thank you for the issue and the line numbers, this is very useful. I uploaded a new OBF (OBF45) with the public schema removed. Now, it still gets created automatically with the postgres superuser as the owner, which can be troublesome (you can't do anything with it if you dont have the superuser credentials), but so far the public schema has never gotten in my way.

…

On Wed, May 3, 2023 at 7:27 PM Renée F. Brown ***@***.***> wrote: The following errors occur when running OBF on setup: ERROR: schema "public" already exists ALTER SCHEMA ERROR: must be owner of schema public I confirmed that the public table is created automatically, with postgres as the owner on Ubuntu 20.04, PostgreSQL 15.2. Removing the relevant lines from OBF resolves the issue. To resolve, lines 76-94 should be removed from OBF. Alternatively, the script could be modified to check these things and only execute if necessary. I was going to do a pull request with line removal fix, but the contributing guidelines scared me away... — Reply to this email directly, view it on GitHub <#102>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AKAZD5RTEFWBKJDTI25CRFLXELZWTANCNFSM6AAAAAAXVC6VZM> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>