Re: Incorrect "ERROR: database "xxx" is being accessed by other users"

Поиск

Список

Период

Сортировка

От	Dmitry Koterov
Тема	Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Дата	13 марта 2007 г. 05:41:54
Msg-id	d7df81620703130141l41c2208bl87494ef4f7a8d75a@mail.gmail.com обсуждение
Ответ на	Re: Incorrect "ERROR: database "xxx" is being accessed by other users" (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы	Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Список	pgsql-general

Дерево обсуждения

Yes, I have one!
How to remove it now? I tried DEALLOCATE for gid returned by

select * from pg_prepared_xacts;

but it says "prepared statement does not exist"...
Database restart does not reset the prepared transaction...

On 3/13/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:

"Dmitry Koterov" <dmitry@koterov.ru> writes:
> I have a database which I cannot delete (the same for rename):
> ERROR:  database "xxx" is being accessed by other users
> But it is NOT accessed by anybody, because:

Have you checked for prepared transactions in that DB?  See
pg_prepared_xacts view (I've been burnt by that myself...)

                        regards, tom lane

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: Incorrect "ERROR: database "xxx" is being accessed by other users"