Carol Walter <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
