On Tue, Jul 16, 2024 at 5:01 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> writes:
> > On Mon, Jul 15, 2024 at 10:55 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> Uh ... does this ensure that the data hasn't changed?
>
> > postgres_fdw opens a remote transaction using REPEATABLE READ or
> > SERIALIZABLE, so the recreated cursor uses the same snapshot except
> > changes made by the remote transaction.
>
> Ah, right.
Pushed and back-patched to v15 after adding a comment for the test
case. Thanks for reviewing!
Best regards,
Etsuro Fujita