On Wednesday, September 11, 2024, Andrei Lepikhov <lepihov(at)gmail(dot)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.