Re: Table appears on listing but can't drop it

On 01/08/2010 08:39 AM, Fernando Morgenstern wrote:
> 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

You have a space at the beginning of the name. Try:

drop database " skynet";

--
Adrian Klaver
adrian.klaver@gmail.com