On Mon, Mar 17, 2008 at 08:45:59AM -0700, Gauthier, Dave wrote: > stdb=# select oid,ctid,xmin,xmax,datname from pg_database > stdb-# ; > oid | ctid | xmin | xmax | datname > --------+--------+---------+------+-------------- > 10819 | (0,1) | 592 | 0 | postgres > 1 | (0,6) | 585 | 0 | template1 > 10818 | (0,7) | 586 | 0 | template0 > 823888 | (0,13) | 761678 | 0 | cells_dev > 19810 | (0,49) | 497579 | 0 | stdb2 > 597974 | (3,2) | 2346578 | 0 | stdb > 19882 | (3,3) | 2346580 | 0 | stdb_standby > 16384 | (3,4) | 2364457 | 0 | cells > (8 rows) > > mmdcc228> dropdb stdb > ERROR: database "stdb" does not exist > STATEMENT: DROP DATABASE stdb; > dropdb: database removal failed: ERROR: database "stdb" does not exist > mmdcc228>
try this: while connected to stdb (in psql): \connect template1 drop database stdb; depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
