Re: Add a hook for handling logical decoding messages on subscribers.

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Zhijie Hou <houzhijie22(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add a hook for handling logical decoding messages on subscribers.
Date: 2026-11-13 23:35:02
Message-ID: CAD21AoDQdj2xouprHesGvSFGVwZYJJp=qZfgUL6m_HLdEMvaoQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Nov 12, 2026 at 2:06 AM Bertrand Drouvot
<bertranddrouvot(dot)pg(at)gmail(dot)com> wrote:
>
> Hi,
>
> Sorry for joining this discussion so late.
>
> On Thu, Nov 12, 2026 at 03:02:44PM +0530, Amit Kapila wrote:
> > On Thu, Nov 12, 2026 at 4:10 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
> > >
> > > On Mon, Nov 9, 2026 at 5:21 PM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
> > > >
> > > > I've attached the new patches. I just updated the commit message for
> > > > the 0001 patch, and added some fixes and regression tests for the 0002
> > > > patch. Please review them.
> > >
> > > I think the 0001 patch can be pushed independently. So I'm going to
> > > push it to master, barring objections.
> > >
> >
> > Few comments on 0001:
> > * As we are planning this as a master-only change, will it be better
> > if we just pass subxid as a separate parameter to keep the interface
> > consistent with other similar interfaces and avoid the need for
> > plugins to retrieve toptxn separately.
>
> +1. That would also prevent the crash mentioned in the commit message, as txn
> would remain the top level transaction.
>
> Regards,

Agreed. It's better for callbacks to get both top-level and
subtransaction's ids.

I've updated the patches (the 0002 patch unchanged).

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

Attachment Content-Type Size
v8-0002-Add-a-hook-for-handling-logical-messages-on-subsc.patch text/x-patch 121.3 KB
v8-0001-Add-an-xid-argument-to-the-logical-decoding-messa.patch text/x-patch 19.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Lukas Fittl 2026-11-14 00:14:50 Re: [BUG / PATCH] PG19: VACUUM misestimates reltuples (often 0) after on-access VM setting
Previous Message Tom Lane 2026-11-13 23:11:49 Re: Let's drop support for named POSIX semaphores