Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Apr 18, 2022 at 4:07 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> There may be some corner cases that aren't described by any of these
>> three blanket scenarios, but they've got to be pretty few and far
>> between.
> My first thought whenever anything like this comes up is cursors,
> especially but not only holdable cursors. Also, plpgsql variables,
> maybe mixed with embedded COMMIT/ROLLBACK.
Those exact cases have had detoasting bugs in the past and are now fixed.
> I don't find it
> particularly hard to believe we have some bugs in
> insufficiently-well-considered parts of the system that pass around
> datums outside of the normal executor flow, but I don't know exactly
> how to find them all, either.
I'm not here to claim that there are precisely zero remaining bugs
of this ilk. I'm just saying that I think we've flushed out most
of them. I think there is some value in trying to think of a way
to prove that none remain, but it's not a problem we can solve
for v15.
regards, tom lane