Re: Accept invalidation messages before the query starts inside a transaction - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Accept invalidation messages before the query starts inside a transaction
Date
Msg-id CAKFQuwYbDPg8-+iU-7kBk39juXbQ-1taAKLFSSzb2uGRimbBxw@mail.gmail.com
Whole thread Raw
Responses Re: Accept invalidation messages before the query starts inside a transaction
List 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 by date:

Previous
From: Nazir Bilal Yavuz
Date:
Subject: Re: Avoid dead code (contrib/pg_visibility/pg_visibility.c)
Next
From: Hunaid Sohail
Date:
Subject: Re: [PATCH] Add roman support for to_number function