| From: | Fernando Morgenstern <fernando(at)consultorpc(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Table appears on listing but can't drop it |
| Date: | 2010-01-08 16:39:03 |
| Message-ID: | C73C523E-CDD2-499E-8DC8-99891B354929@consultorpc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)consultorpc(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2010-01-08 16:41:50 | Re: Table appears on listing but can't drop it |
| Previous Message | Tom Lane | 2010-01-08 16:33:34 | Re: Rows missing from table despite FK constraint |