Table appears on listing but can't drop it

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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