On Wed, Sep 25, 2024 at 1:53 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Ron Johnson <ronljohnsonjr@xxxxxxxxx> writes:
> But why does "SELECT 1;" need a snapshot? Heck, why does "SELECT
> <immutable>;" need a snapshot?
Because we're not going to analyze the statement in the amount of
depth needed to make that distinction before we crank up the
transactional machinery. If it says SELECT, it gets a snapshot.
Perfectly reasonable.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!