Re: Question about MVCC caveats

2025-11-13 Thread Laurenz Albe
On Thu, 2025-11-13 at 13:30 -0600, Jim Nasby wrote: > At [1], the docs state that table rewrite ALTERs result in the relation > appearing > empty after the ALTER if another transaction had already taken a snapshot > before > the ALTER. A simple test with a repeatable read (or serializable) transa

Question about MVCC caveats

2025-11-13 Thread Jim Nasby
At [1], the docs state that table rewrite ALTERs result in the relation appearing empty after the ALTER if another transaction had already taken a snapshot before the ALTER. A simple test with a repeatable read (or serializable) transaction confirms this... but is there any other situation where a