Re: DROP DATABASE always seeing database in use

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: DROP DATABASE always seeing database in use
Дата
Msg-id 20080804140134.GA29797@winnie.fuhr.org
обсуждение исходный текст
Ответ на DROP DATABASE always seeing database in use  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: DROP DATABASE always seeing database in use  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
On Mon, Aug 04, 2008 at 11:51:35AM +0100, Gregory Stark wrote:
> It seems there's something wrong with CheckOtherDBBackends() but I haven't
> exactly figured out what. There are no other sessions but drop database keeps
> saying "regression" is being accessed by other users.

Are any prepared transactions still open?

select * from pg_prepared_xacts;

-- 
Michael Fuhr


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jorgen Austvik - Sun Norway
Дата:
Сообщение: Re: pg_regress inputdir
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unnecessary code in_bt_split