public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jim Nasby <[email protected]>
To: [email protected]
Subject: Question about MVCC caveats
Date: Thu, 13 Nov 2025 13:30:44 -0600
Message-ID: <CAMFBP2oW2xRBJZjpjtLJ_hjLM5fMMA7Sv9SigK5XA5XKXpYyWA@mail.gmail.com> (raw)
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?
1: https://www.postgresql.org/docs/current/mvcc-caveats.html
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Question about MVCC caveats
In-Reply-To: <CAMFBP2oW2xRBJZjpjtLJ_hjLM5fMMA7Sv9SigK5XA5XKXpYyWA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox