Re: [PATCH] proposal to surface index used by replica identity

Hi Peter,

On Mon, Jun 15, 2026 at 2:50 AM Peter Travers <traverspw(at)gmail(dot)com> wrote:
>
> Hi,
>
> We are building internal CDC tooling and have found it challenging to identify which index is used as the replica identity for a publication. I propose adding two new columns, replident and replidentidx, to the pg_publication_tables catalog view 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 a valuable 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