From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Fernando Morgenstern <fernando(at)consultorpc(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Table appears on listing but can't drop it |
Date: | 2010-01-08 16:41:50 |
Message-ID: | 4B47604E.5050702@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)consultorpc(dot)com
You have a space at the beginning of the name. Try:
drop database " skynet";
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2010-01-08 16:44:16 | Re: Table appears on listing but can't drop it |
Previous Message | Fernando Morgenstern | 2010-01-08 16:39:03 | Table appears on listing but can't drop it |