Re: Report replica identity in pg_publication_tables

From: Melih Mutlu <m(dot)melihmutlu(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Report replica identity in pg_publication_tables
Date: 2025-07-01 14:28:30
Message-ID: CAGPVpCQPe0Nk6=Kqggc9zXs5GJ-MRDmQLT0DEJ0X-DVuKp3SQA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Ashutosh,

Thanks for the patch.

Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, 30 Haz 2025 Pzt, 13:14
tarihinde şunu yazdı:

> The replica identity of a given table is not a property of
> publication, per say, so it's arguable whether it should be included
> in pg_publication_tables or not. But the output seems to be useful.
> E.g. from the tests
>

To my understanding, pg_publication_tables doesn’t just contain publication
properties, but also information about the tables included in the
publication. As long as the exposed information about the published tables
is relevant in the context of publications in logical replication, I think
it’s reasonable to include it in pg_publication_tables. IMHO replica
identity seems like relevant information.

Regards,
--
Melih Mutlu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2025-07-01 14:31:01 Re: Add os_page_num to pg_buffercache
Previous Message Daniel Gustafsson 2025-07-01 14:24:40 Re: No error checking when reading from file using zstd in pg_dump