Request a Demo
Home   >   mailing lists

Re: [PATCH] proposal to surface index used by replica identity - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: [PATCH] proposal to surface index used by replica identity
Date
Msg-id CAExHW5tQ-9-Xp-WqO+L3FZ+NgoE5z-yTmEA1kdz1Nb6FPhX=dA@mail.gmail.com
Whole thread
In response to [PATCH] proposal to surface index used by replica identity  (Peter Travers <traverspw@gmail.com>)
Responses Re: [PATCH] proposal to surface index used by replica identity
List pgsql-hackers
Tree view 
Hi Peter,

On Mon, Jun 15, 2026 at 2:50 AM Peter Travers <traverspw@gmail.com> wrote:
>
> Hi,
>
> We are building internal CDC tooling and have found it challenging to identify which index is used as the replica
identityfor a publication. I propose adding two new columns, replident and replidentidx, to the pg_publication_tables
catalogview so users can easily see this configuration. 
>
> I have attached a patch with the implementation and updated regression tests. Please let me know if you feel this is
avaluable addition or if you have any concerns with this approach. 

I had proposed something closely related to this in
https://www.postgresql.org/message-id/CAExHW5sSmbnFCiMX=smSQSdaxkWPvZbMYaZq2bSE7+SD5wSWOA@mail.gmail.com.
We are discussing possible options when the publishing via root. Maybe
you could add your proposal to that thread and also help us take the
discussion forward there.

--
Best Wishes,
Ashutosh Bapat

pgsql-hackers by date:

Previous
From: Ashutosh Sharma
Date:
Subject: Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication
Next
From: Dilip Kumar
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication