cannot remove schema public
От | Szymon Guz |
---|---|
Тема | cannot remove schema public |
Дата | |
Msg-id | CAFjNrYu8GqD=17DimG9QtWoV1hPviqHxaZp2umWAPkpUOFAGYg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: cannot remove schema public
Re: cannot remove schema public |
Список | pgsql-admin |
Hi,
while writing some tests for an application, I want to remove all tables and all schemas before running tests.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
Szymon
В списке pgsql-admin по дате отправления: