On Wed, Sep 25, 2024 at 1:53 PM Tom Lane <t...@sss.pgh.pa.us> wrote:

> Ron Johnson <ronljohnso...@gmail.com> 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!

Reply via email to