Request a Demo
Home   >   mailing lists

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

From Peter Travers
Subject Re: [PATCH] proposal to surface index used by replica identity
Date
Msg-id CAO1T5yR3fp7W+8RWa6z3kz9ix2Hsa0qTzUHbuXJS05Nx1+8Xdw@mail.gmail.com
Whole thread
In response to Re: [PATCH] proposal to surface index used by replica identity  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
List pgsql-hackers
Tree view
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.bapat.oss@gmail.com> wrote:
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 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

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: typedef struct WindowClause misleading comments
Next
From: Tender Wang
Date:
Subject: Re: assertion failure with unique index + partitioning + join