On Mon, Apr 18, 2022 at 4:07 PM Tom Lane <t...@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. 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. -- Robert Haas EDB: http://www.enterprisedb.com