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.
|
| Список | 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 по дате отправления: