Table appears on listing but can't drop it
От | Fernando Morgenstern |
---|---|
Тема | Table appears on listing but can't drop it |
Дата | |
Msg-id | C73C523E-CDD2-499E-8DC8-99891B354929@consultorpc.com обсуждение исходный текст |
Ответы |
Re: Table appears on listing but can't drop it
Re: Table appears on listing but can't drop it Re: Table appears on listing but can't drop it |
Список | pgsql-general |
Hello, I'm running version 8.4.1 and have a table that appears on listing ( when i run \l ) but i can't drop it. Example: postgres=# \l List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- skynet | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | t1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres postgres=# drop database skynet; ERROR: database "skynet" does not exist I intentionally removed other databases name. Also, i verified that i can run CREATE DATABASE skynet having two databases with the same name. Any ideas of what causes this problem? Regards, --- Fernando Marcelo www.consultorpc.com fernando@consultorpc.com
В списке pgsql-general по дате отправления: