| From: | Peter Travers <traverspw(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | [PATCH] proposal to surface index used by replica identity |
| Date: | 2026-06-14 21:19:41 |
| Message-ID: | CAO1T5yT0f7bj+GV_LEa+DFrMhfZxA7Om07E4FBS848o=EsaTig@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| replica_identity_enhancements.patch | text/x-patch | 20.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2026-06-14 23:07:20 | Re: Use \if/\endif to remove non-libxml2 expected output in regression tests |
| Previous Message | Zsolt Parragi | 2026-06-14 20:51:31 | Re: LDAP timeout options |