Re: what happens if a failed transaction is not rolled back?

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: what happens if a failed transaction is not rolled back?
Дата
Msg-id CAHyXU0whm0B03a60KtLjoty=JHVoO0GSDip7b0q3a2F6nrcEdg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: what happens if a failed transaction is not rolled back?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, Apr 24, 2023 at 8:41 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Merlin Moncure <mmoncure@gmail.com> writes:
> Hm. I also noticed when looking at this that aborted transactions with
> savepoints are not subjected to the idle_in_transaction timeout which is a
> bit surprising.

Hmm ... I think it's intentional that idle_in_transaction no longer
applies once the transaction has failed.  But if there's a live
savepoint, then we should enforce it since resources may still be
held.  Seems like a bug, if your observation is accurate.


hm,  double checking, it's not.

merlin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: what happens if a failed transaction is not rolled back?
Следующее
От: jian he
Дата:
Сообщение: wiki.postgres ​ Tighten trigger permission checks already resolved