Re: Proposal: Conflict log history table for Logical Replication

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Proposal: Conflict log history table for Logical Replication
Date: 2026-01-19 03:22:21
Message-ID: CAHut+Pt4TUbv509p0RvS-uY_ZzVcgJuKNyVg8_BBZ+SsC16ysw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Some review comments for v22-0002

======
1. Nit. "JSON" versus "json" capitalisation

Whichever way you choose, the patch should have consistent
capitalisation in all your comments.

Sometimes UPPERCASE
-------------------

single JSON array in the local_conflicts column.

The JSON array uses the following structured format:

+/* Schema for the elements within the 'local_conflicts' JSON array */

+ /* Convert to a JSON datum. */

+ * Builds the local conflicts JSON array column from the list of

+ /* Process local conflict tuple list and prepare an array of JSON. */

+ /* Convert conflicting tuple to JSON datum. */

+ * Build the higher level JSON datum in format described in function

+# Verify that '2' is present inside the JSON structure using a regex

+# Verify that '6' is present inside the JSON structure using a regex

Sometimes lowercase
-------------------

+ * Fetch replica identity key from the tuple table slot and convert into a
+ * json datum.

+ List *json_datums = NIL; /* List to hold the row_to_json results
(type json) */

+ /* Construct the json[] array Datum. */

+ * json datum from key value. Otherwise, construct it from the complete

======
src/backend/replication/logical/conflict.c

tuple_table_slot_to_json_datum:

2.
+ * Helper function to convert a TupleTableSlot to Jsonb.

This 'Jsonb' comment was accidentally missed when you changed all
previous jsonb to json?

======
Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2026-01-19 03:47:08 Re: ON CONFLICT DO SELECT (take 3)
Previous Message Michael Paquier 2026-01-19 03:18:24 Re: pg_stat_statements: Fix nested tracking for implicitly closed cursors