Unable to drop DB in latest CVS version

[Ed L.]

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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Ed L.]

On Tuesday September 21 2004 4:01, Ed L. wrote:

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

Duh. Operator error.

Ed
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org