public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Jim Nasby <[email protected]>
To: [email protected]
Subject: Re: Question about MVCC caveats
Date: Thu, 13 Nov 2025 23:10:18 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMFBP2oW2xRBJZjpjtLJ_hjLM5fMMA7Sv9SigK5XA5XKXpYyWA@mail.gmail.com>
References: <CAMFBP2oW2xRBJZjpjtLJ_hjLM5fMMA7Sv9SigK5XA5XKXpYyWA@mail.gmail.com>
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) transaction
> confirms this... but is there any other situation where a snapshot would be taken?
Snapshots are taken at the start of a statement (or, with REPEATABLE READ and
SERIALIZABLE) at the beginning of the first statement in the transaction.
What do you mean with an "other" situation?
Yours,
Laurenz Albe
view thread (2+ messages)
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], [email protected]
Subject: Re: Question about MVCC caveats
In-Reply-To: <[email protected]>
* 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