Table appears on listing but can't drop it - Mailing list pgsql-general

From Fernando Morgenstern
Subject Table appears on listing but can't drop it
Date
Msg-id C73C523E-CDD2-499E-8DC8-99891B354929@consultorpc.com
Whole thread Raw
Responses Re: Table appears on listing but can't drop it  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Table appears on listing but can't drop it  (Sam Mason <sam@samason.me.uk>)
Re: Table appears on listing but can't drop it  (hubert depesz lubaczewski <depesz@depesz.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rows missing from table despite FK constraint
Next
From: Adrian Klaver
Date:
Subject: Re: Table appears on listing but can't drop it