Question about MVCC caveats - Mailing list pgsql-general

From Jim Nasby
Subject Question about MVCC caveats
Date
Msg-id CAMFBP2oW2xRBJZjpjtLJ_hjLM5fMMA7Sv9SigK5XA5XKXpYyWA@mail.gmail.com
Whole thread Raw
Responses Re: Question about MVCC caveats
List pgsql-general
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 snapshot would be taken?

pgsql-general by date:

Previous
From: pg254kl@georgiou.vip
Date:
Subject: Re: Forcing Index usage
Next
From: Laurenz Albe
Date:
Subject: Re: Question about MVCC caveats