Re: postgres_fdw: transaction mode inheritance corner cases

On Fri, Oct 2, 2026 at 2:30 AM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> On Thu, Oct 1, 2026 at 3:27 AM Matheus Alcantara
> <matheusssilv97(at)gmail(dot)com> wrote:
> > 1: read-write local transactions can no longer query a hot standby
>
> Ah, I think this is too restrictive, so I changed my mind; I'd like to
> propose to keep the current behavior and instead modify the
> documentation like this:

Sorry I forgot this example:

Local READ ONLY transactions propagate their read-only mode to remote
sessions. (This is also applied to subtransactions.) Note that this
does not prevent login triggers executed on remote servers from
writing.
Also, local DEFERRABLE transactions propagate their deferrable mode to
remote sessions. (This is only applied to remote servers 9.1 and
newer.)

Best regards,
Etsuro Fujita