Re: Proposal: Conflict log history table for Logical Replication
vignesh C <vignesh21@gmail.com>
From: vignesh C <vignesh21@gmail.com>
To: Peter Smith <smithpb2250@gmail.com>
Cc: Dilip Kumar <dilipbalaut@gmail.com>,
shveta malik <shveta.malik@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>,
Nisha Moond <nisha.moond412@gmail.com>, Masahiko Sawada <sawada.mshk@gmail.com>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-17T13:03:52Z
Lists: pgsql-hackers
On Mon, 15 Jun 2026 at 14:29, Peter Smith <smithpb2250@gmail.com> wrote:
>
> Some review comments for v50-0004.
>
> ======
> src/bin/pg_dump/pg_dump.c
>
> dumpSubscription:
>
> 1.
> + * We skip the default value ('log') to match the handling of other
> + * default subscription options.
> + */
>
> There is only one "default", so I think this should say "...other
> subscription options", not "...other default subscription options".
modified
> ======
> src/include/catalog/pg_subscription.h
>
> 2.
> +#define CONFLICT_LOG_RELATION_NAME_FMT "pg_conflict_log_%u"
> +
>
> 2a.
> This format string (and first usage of it) really be in one of the
> earlier patches.
This was implemented in this patch, as prior to it there was only a
single instance of its usage.
> ~
>
> 2b.
> Add a comment to explain that the %u is the subscription oid.
Added it
> ~
>
> 2c.
> Is this the correct header file for this? IMO it is CLT specific, so
> belongs in conflict.h.
I should be kept in pg_subscription.h, as it is also required by the frontend.
These changes for the same are available in the v51 version patch posted at [1].
[1] - https://www.postgresql.org/message-id/CALDaNm2r_5hmz22Gsio%3DOABvA%3Dc_cr8avv%3Dy19Epb0vKMo%2BQJQ%40mail.gmail.com
Regards,
Vignesh
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Allow logical replication conflicts to be logged to a table.
- a5918fddf10d master landed
-
Avoid orphaned objects dependencies
- 2fbb21170e90 19 (unreleased) cited