On 4/21/25 07:46, Frédéric Yhuel wrote:
> On 4/20/25 00:42, Sami Imseih wrote:
>>> (In my testing, the "temporary file:" message comes
>>> out without any attached STATEMENT most of the time already, so this
>>> isn't losing much as far as that's concerned.)
>
>
> Indeed, this happens when using autocommit / implicit transactions.
Actually, this also happens with Java-style cursors, i.e. using the
setFetchSize(<count>) method, which pgJDBC converts to using named
portals and EXECUTE <name> <count> protocol messages.
The explanation is probably very similar to the one Sami gave for the
implicit transaction case.
In any case, my v3 patch seems to fix all these cases.
(I'm not saying it's good enough to be committed as is. I think I should
at least add some comments. Anything else?)
