If frontend dies?

Поиск
Список
Период
Сортировка
От Leon
Тема If frontend dies?
Дата
Msg-id 378F1294.8FEE6E04@udmnet.ru
обсуждение исходный текст
Список pgsql-general
Hi!

It's me again. One more question:

Suppose you begin a transaction, create a table and then your
frontend dies. Backend still thinks that transaction is in
progress and doesn't allow creation of table with the same
name to other frontends. Restarting postmaster doesn't help.

So here is the question: what do I do with such 'zombie'
transactions? (The answer, I think , should have been in FAQ.)

--
Leon.


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

Предыдущее
От: Leon
Дата:
Сообщение: Re: [GENERAL] Weird behavior of 'default user'
Следующее
От: Michael Doornbos
Дата:
Сообщение: concurrent connections