Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Fri, Jan 8, 2010 at 9:58 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
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:

Oops should be  "is not the same as the one  below"


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@xxxxxxxxx



--
Adrian Klaver
adrian.klaver@xxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux