From: | Fernando Morgenstern <fernando(at)consultorpc(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Table appears on listing but can't drop it |
Date: | 2010-01-08 17:53:38 |
Message-ID: | D8497632-43FC-404C-B036-5F963C4E984F@consultorpc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Em 08/01/2010, às 15:49, Adrian Klaver escreveu:
> On 01/08/2010 08:55 AM, Fernando Morgenstern wrote:
>
>> Hello,
>>
>> Thanks for your quick answers. The extra space is indeed a copy-and-paste issue. Here it is the select that you suggested:
>>
>> postgres=# select '"' || datname || '"' from pg_database;
>> ?column?
>> -------------
>> "template1"
>> "template0"
>> "t1"
>> "skynet"
>>
>>
>> Best Regards,
>> ---
>>
>> Fernando Marcelo
>> www.consultorpc.com
>> fernando(at)consultorpc(dot)com
>
> Can you connect to it?
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
No, i get this:
$ psql skynet
psql: FATAL: database "skynet" does not exist
I can create a database with the same name:
postgres=# create database skynet;
CREATE DATABASE
postgres=# select '"' || datname || '"' from pg_database;
?column?
-------------
"template1"
"template0"
"postgres"
"t1"
"skynet"
"skynet"
And drop the newly created database:
postgres=# drop database skynet;
DROP DATABASE
postgres=# select '"' || datname || '"' from pg_database;
?column?
-------------
"template1"
"template0"
"postgres"
"t1"
"pgpool"
"skynet"
Strange, isn't it?
Regards,
---
Fernando Marcelo
www.consultorpc.com
fernando(at)consultorpc(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Morgan Lloyd | 2010-01-08 17:57:31 | Re: Server name in psql prompt |
Previous Message | Keaton Adams | 2010-01-08 17:50:12 | Re: WAL Log Shipping - Warm Standby not working under 8.3.7 |