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

On 01/08/2010 09:53 AM, Fernando Morgenstern wrote:

Actually what is strange is that your previous listing :

postgres=# select '"' || datname || '"' from pg_database;
  ?column?
 -------------
 "template1"
 "template0"
 "t1"
 "skynet"

is not the same as the one above:

postgres=# select '"' || datname || '"' from pg_database;
 ?column?
-------------
 "template1"
 "template0"
 "postgres"
 "t1"
 "pgpool"
 "skynet"

In particular the presence of postgres,t1 and pgpool.

Are you sure which cluster you are pointing at and whether the psql version matches the server version?

--
Adrian Klaver
adrian.klaver@gmail.com