Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw
Date: 2026-03-04 23:52:22
Message-ID: CAPmGK14ZTHRGPprEhzEe2TJxaCcjNVeWw6tue_gqp=9DzqYnMA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Feb 25, 2026 at 7:22 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)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 Content-Type Size
v7-0001-postgres_fdw-Inherit-the-local-transaction-s-access-.patch application/octet-stream 17.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2026-03-05 00:00:55 Re: pgsql: postgres_fdw: Inherit the local transaction's access/deferrable
Previous Message paul.bunn 2026-03-04 23:33:24 RE: [BUG + PATCH] DSA pagemap out-of-bounds in make_new_segment odd-sized path