On Wednesday, September 11, 2024, Andrei Lepikhov <
lepihov@gmail.com> wrote:
I don't know whether to classify this as a bug.
[1] https://www.postgresql.org/docs/16/mvcc-caveats.html
Seems we need to add another sentence to that final paragraph. Something like:
However, once an object is accessed within a transaction its definition is cached for the duration of the transaction. Of particular note are routine bodies modified using create or replace. If a replacement gets committed mid-transaction the old code body will still be executed for the remainder of the transaction.
David J.