Re: Reject WAIT FOR earlier in transaction-snapshot mode - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: Reject WAIT FOR earlier in transaction-snapshot mode
Date
Msg-id CAN12+YLvZW7ScNdWZchKz=9Zyc4f3ZfFjVwz=HO4M0nfcOeDOQ@mail.gmail.com
Whole thread
In response to Re: Reject WAIT FOR earlier in transaction-snapshot mode  (Xuneng Zhou <xunengzhou@gmail.com>)
List pgsql-hackers
> > I don't think there is a good use-case here where someone will do:
> >
> > BEGIN ISOLATION LEVEL REPEATBLE READ; WAIT FOR LSN ...;
> > SELECT ...
>
> Can you please elaborate on why this is not a good use-case?

Because I was thinking that calling WAIT FOR LSN before
BEGIN ISOLATION LEVEL ... is equivalent to calling it after, since the
transaction snapshot is not taken until the first SELECT.  However, I can
see how requiring that order could be problematic, especially when the
driver issues BEGIN ISOLATION LEVEL ... automatically.

--
Sami Imseih
Amazon Web Services (AWS).



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: DSA_ALLOC_NO_OOM vs dsm_create ERROR leaving a half-initialized pgstats hash entry
Next
From: Tom Lane
Date:
Subject: Re: remove_useless_joins vs. bug #19560