Re: BUG #8095: postgres acquiring lock on a table when not in transaction

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #8095: postgres acquiring lock on a table when not in transaction
Дата
Msg-id 9653.1366491731@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #8095: postgres acquiring lock on a table when not in transaction  (vaiayand@gmail.com)
Список pgsql-bugs
vaiayand@gmail.com writes:
> We investigated one issue and found the following:
> postgres is acquiring a lock on table when not in trancation during prepared
> ROLLBACK statement. It is releasing the acquired lock at end.
> but postgres should not get lock on a table when not in transaction. After
> acquiring any lock, if backend process dies (say SIGTERM signal), the
> postgres will be in lock-not-released state.

Thanks for the report.  I believe I've fixed this.

            regards, tom lane

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

Предыдущее
От: Nachiket Vaidya
Дата:
Сообщение: missing attachment for bug 8095
Следующее
От: E E
Дата:
Сообщение: Re: BUG #8056: postgres forgets hstore over time