On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter <walterc@xxxxxxxxxxx> wrote: > 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) What does "select * from pg_stat_activity say about this db? > This database is one that I created just a few hours ago just to test some > things myself. There can be no one in it except me. I completely closed Correct me if I'm wrong, but isn't that enough ((just you) to cause the drop database to fail? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
