On Wednesday, September 11, 2024, Andrei Lepikhov <lepi...@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.
