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 <[email protected]> wrote: > Hi Peter, > > On Mon, Jun 15, 2026 at 2:50 AM Peter Travers <[email protected]> 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+sd5ws...@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 >
