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

Поиск
Список
Период
Сортировка
От Dmitry Koterov
Тема Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Дата
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Incorrect "ERROR: database "xxx" is being accessed by other users"
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Incorrect "ERROR: database "xxx" is being accessed by other users"