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

Hey Ashutosh,

Good catch, I missed that thread. I'll catch-up and see if I have anything
to add

Cheers,

Peter

On Mon, Jun 15, 2026, 06:47 Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
wrote:

> 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
>