Postgres Pro
Downloads
Home   >   mailing lists

cannot remove schema public - Mailing list pgsql-admin

From Szymon Guz
Subject cannot remove schema public
Date
Msg-id CAFjNrYu8GqD=17DimG9QtWoV1hPviqHxaZp2umWAPkpUOFAGYg@mail.gmail.com
Whole thread Raw
Responses Re: cannot remove schema public  (Thomas Kellerer <spam_eater@gmx.net>)
Re: cannot remove schema public  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
Hi,
while writing some tests for an application, I want to remove all tables and all schemas before running tests.

For the schema public I want to remove it and create again. However that doesn't work, I'm wondering if that's on purpose, or it's a kind of a bug.

I'm using user 'szymon' in my console.

Then I created a user:

create user test password 'test';

and database

create database test owner test;

I logged into the database as the user:

test=# \c test test
You are now connected to database "test" as user "test".

And the owner of the public schema is not test, however it's an owner of the test database.

test=# \dn
 List of schemas
  Name  | Owner 
--------+--------
 public | szymon
(1 row)

When I try to remove the public schema, then I get:

test=> drop schema public cascade;
ERROR:  must be owner of schema public

regards,
Szymon

pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: WAL archiving to 2 standby servers
Next
From: Thomas Kellerer
Date:
Subject: Re: cannot remove schema public