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

On 12/9/2024 08:31, David G. Johnston wrote: On Wednesday, September 11, 2024, Andrei Lepikhov > wrote: I don't know whether to classify this as a bug. [1] https://www.postgresql.org/docs/16/mvcc-caveats.html

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

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

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

> On 12 Sep 2024, at 00:50, Andrei Lepikhov wrote: > > It happens because of documented behaviour [1], which doesn't guarantee > isolation levels for internal access to the system catalogues. As far as I understood you are proposing not isolation guaranties, but allowed isolation anomaly.

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

Andrei Lepikhov writes: > I don't know whether to classify this as a bug. The sketch of the patch > with an example isolation test is attached. This seems like an extremely strange place (and an extremely brute-force way) to insert an AcceptInvalidationMessages call. Under what circumstances wou