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

From Peter Travers
Subject [PATCH] proposal to surface index used by replica identity
Date
Msg-id CAO1T5yT0f7bj+GV_LEa+DFrMhfZxA7Om07E4FBS848o=EsaTig@mail.gmail.com
Whole thread
Responses Re: [PATCH] proposal to surface index used by replica identity
List pgsql-hackers
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.

Thanks,
Peter Travers

Engineer
linear.app

Attachment

pgsql-hackers by date:

Previous
From: Zsolt Parragi
Date:
Subject: Re: LDAP timeout options
Next
From: Michael Paquier
Date:
Subject: Re: Use \if/\endif to remove non-libxml2 expected output in regression tests