Re: Repeatable Read Isolation Level "transaction start time"

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Repeatable Read Isolation Level "transaction start time"
Date: 2024-09-25 20:53:30
Message-ID: DD2C10F3-2A3C-44AB-AAC5-10BB15B15498@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Sep 25, 2024, at 13:49, Greg Sabino Mullane <htamfids(at)gmail(dot)com> wrote:
> BEGIN ISOLATION MODE REPEATABLE READ SNAPSHOT NOW;

This might well be a failure of imagination on my part, but when would it pragmatically matter that the snapshot is taken at the first statement as opposed to at BEGIN?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durgamahesh Manne 2024-09-25 20:53:39 Re: Synchronize the dump with a logical slot with --snapshot
Previous Message Greg Sabino Mullane 2024-09-25 20:49:34 Re: Repeatable Read Isolation Level "transaction start time"