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-02-25 10:22:26
Message-ID: CAPmGK14RxMWYmNEHcjn04ZuvqxZrbasPT+zMNdd3T2V3R9Rz2A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Jun 1, 2025 at 5:44 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> On Sun, May 25, 2025 at 2:39 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> > Here is a new version of the patch where I added a comment for a new
> > function, fixed indentation, and added the commit message. If there
> > are no objections, I will push this as a master-only fix, as noted in
> > the commit message.
>
> Pushed after extending the comment a little bit.

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.

Best regards,
Etsuro Fujita

[1] https://www.postgresql.org/message-id/CAPmGK14yYoO2iBg7SoT3WdnAKoCpWy_LPdoTDepJ21-Yf8TiKA%40mail.gmail.com

Attachment Content-Type Size
v6-0001-postgres_fdw-Inherit-the-local-transaction-s-access-.patch application/octet-stream 16.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2026-02-25 10:27:48 Re: pgsql: libpq: Grease the protocol by default
Previous Message Bertrand Drouvot 2026-02-25 10:21:57 Re: Warning-suppression fixes we ought to back-patch