Re: BUG #17840: Failing to execute auto_explain for logging leads to transaction rollback.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17840: Failing to execute auto_explain for logging leads to transaction rollback.
Дата
Msg-id CAKFQuwa2efAF3VWVVoSQBMUTYx3FsERx2y+o93yToEHL88kwzw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17840: Failing to execute auto_explain for logging leads to transaction rollback.  (Sébastien <bokanist@gmail.com>)
Ответы Re: BUG #17840: Failing to execute auto_explain for logging leads to transaction rollback.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
On Wed, Mar 15, 2023 at 11:24 AM Sébastien <bokanist@gmail.com> wrote:
What more can I say ? It's clear that the auto_explain feature, which is a logging process, can make perfectly fine transactions being rolled back. That makes no sense, the transaction should be committed before any logging event is triggered, for me it's a bug in the core of postgres. It has nothing to do with the plugin used.


It may be an undesired behavior, and I do sympathize with the position, but the current design is quite intentional and long-standing and is not going to be treated as a bug to be fixed immediately and back-patched.

A query you can execute should be incapable of failing if EXPLAIN for the same query is issued.  If some interplay with oracle_fdw causes this fundamental assumption to be falsified then auto_explain, which works under that assumption, and oracle_fdw are incompatible and you will need to decide which one (possibly on a per-transaction basis) you wish to use.

David J.

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

Предыдущее
От: Sergei Kornilov
Дата:
Сообщение: Re:Certificate expired
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17840: Failing to execute auto_explain for logging leads to transaction rollback.