Re: Accept invalidation messages before the query starts inside a transaction

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Accept invalidation messages before the query starts inside a transaction
Дата
Msg-id CAKFQuwYbDPg8-+iU-7kBk39juXbQ-1taAKLFSSzb2uGRimbBxw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Accept invalidation messages before the query starts inside a transaction
Список pgsql-hackers
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.

В списке pgsql-hackers по дате отправления: