Carol Walter <walterc@xxxxxxxxxxx> writes: > This has happened or is happening to me again, only this time, it's a > database that I just created. I restored another database into a test > database. One of the tables is empty. I want to drop the test > database and create a new one. When I try to drop the test database, > I get this error - > template1=# drop database km_tezt; > ERROR: database "km_tezt" is being accessed by other users > template1=# select * from pg_prepared_xacts; > transaction | gid | prepared | owner | database > -------------+-----+----------+-------+---------- > (0 rows) Nothing in pg_stat_activity either? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
