Quick Links

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

Re: Repeatable Read Isolation Level "transaction start time" at 2024-09-25 20:49:34 from Greg Sabino Mullane

Responses

Re: Repeatable Read Isolation Level "transaction start time" at 2024-09-25 21:50:06 from Greg Sabino Mullane
Re: Repeatable Read Isolation Level "transaction start time" at 2024-09-25 21:55:54 from Peter J. Holzer

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"