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
