From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | Fernando Morgenstern <fernando(at)consultorpc(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Table appears on listing but can't drop it |
Date: | 2010-01-08 16:48:33 |
Message-ID: | 8017.1262969313@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> writes:
> On 01/08/2010 08:39 AM, Fernando Morgenstern wrote:
>> 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
> You have a space at the beginning of the name. Try:
> drop database " skynet";
I'm not sure about that, because the whole row seems to be offset in
his email. That could be just copy-and-paste sloppiness. Still,
some sort of non-printing character in the name seems to be indicated,
else he'd not have been able to create another db with name "skynet".
Try something like
select '"' || datname || '"' from pg_database
to get a clearer view of what's really in there.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2010-01-08 16:53:40 | Re: Rows missing from table despite FK constraint |
Previous Message | Konrad Garus | 2010-01-08 16:44:32 | Re: Rows missing from table despite FK constraint |