Unable to drop DB in latest CVS version

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Unable to drop DB in latest CVS version
Date: 2004-09-21 22:01:58
Message-ID: 200409211601.58898.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm trying to unsuccessfully to drop a database using the latest
CVS code for 8.0.0, getting the following error:

ERROR: cannot drop the currently open database

So I must have a connection open, right? So I look for
connections with the command I use on 7.3.4 but see nothing:

SELECT pg_stat_get_backend_pid(S.backendid) AS pid,
db.datname AS database, dbu.usename AS user,
pg_stat_get_backend_activity(S.backendid) AS query
FROM pg_user dbu,
(SELECT pg_stat_get_backend_idset() AS backendid) AS S,
pg_database db
WHERE db.oid = pg_stat_get_backend_dbid(S.backendid)
AND dbu.usesysid = pg_stat_get_backend_userid(S.backendid);

pid | database | user | query
-----+----------+------+---------
(0 rows)

So I look at the process table listing:

USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
db2dba 1039 0.0 0.2 114604 3388 pts/3 S 13:49 0:00 postmaster -D /users/db2dba/dbclusters/db2/postgresql-8.0.0beta2/data -i -p 9802
db2dba 1042 0.0 0.1 6720 1544 pts/3 S 13:49 0:00 postgres: logger process
db2dba 1044 0.0 0.5 114740 6836 pts/3 S 13:49 0:00 postgres: writer process
db2dba 1045 0.0 0.2 7736 2592 pts/3 S 13:49 0:00 postgres: stats buffer process
db2dba 1046 0.0 0.1 7044 1856 pts/3 S 13:49 0:00 postgres: stats collector process

Sure don't see anything open. I can stop/restart to get around it,
but wondering what is going on?

Ed

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2004-09-21 22:03:58 Re: Unable to drop DB in latest CVS version
Previous Message Thomas F.O'Connell 2004-09-21 21:17:12 Re: the current scoop on ilike and indexes