Re: Catch-22

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)