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

Thank you for your answers.

Now I understand the problem have been understood.

Oracle_fdw author is working on this.

Best regards

Le mer. 15 mars 2023, 23:06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> a écrit :

> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> > A query you can execute should be incapable of failing if EXPLAIN for the
> > same query is issued.
>
> Indeed. This should be especially true for auto_explain, which isn't
> even doing a re-parse or re-plan, but just dumping data from the
> executor state tree for the just-finished query. Barring edge cases
> like out-of-memory, it really shouldn't fail; so I see no reason why
> we should consider major structural changes to make it (perhaps) less
> likely to fail.
>
> I continue to think that the most likely explanation is oracle_fdw
> doing something it probably shouldn't be doing. I have no interest
> in poking into that code myself, though.
>
> regards, tom lane
>