From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | cannot remove schema public |
Date: | 2014-07-07 09:57:36 |
Message-ID: | CAFjNrYu8GqD=17DimG9QtWoV1hPviqHxaZp2umWAPkpUOFAGYg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2014-07-07 10:19:55 | Re: cannot remove schema public |
Previous Message | Kevin Grittner | 2014-07-02 19:13:28 | Re: WAL archiving to 2 standby servers |