Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw
Date
Msg-id CAPmGK14ZTHRGPprEhzEe2TJxaCcjNVeWw6tue_gqp=9DzqYnMA@mail.gmail.com
Whole thread
In response to Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Responses Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw
List pgsql-hackers
On Wed, Feb 25, 2026 at 7:22 PM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
> This was reverted in commit 7d4667c62.  I'd like to re-propose it for
> v19, as mentioned in [1].  Attached is a new patch, in which I added
> to the documentation a note about login triggers executed on the
> remote side, as discussed in [1].  Other than that, no changes.  I've
> added this to the upcoming CF.

Here is an updated version of the patch.  Changes are:

* On second thought, I think the name of the variable
top_read_only_level added to connection.c by the patch is a bit long,
so I renamed it to top_read_only.  Does that make sense?  Other than
that, no code changes.
* I also added/modified some comments.

Comments welcome!

Best regards,
Etsuro Fujita

Attachment

pgsql-hackers by date:

Previous
From:
Date:
Subject: RE: [BUG + PATCH] DSA pagemap out-of-bounds in make_new_segment odd-sized path
Next
From: Etsuro Fujita
Date:
Subject: Re: pgsql: postgres_fdw: Inherit the local transaction's access/deferrable