pub, sub:
CREATE TABLE tab1 (k timestamptz PRIMARY KEY, v int);

pub:
CREATE PUBLICATION pub1 FOR TABLE tab1;

sub:
create subscription sub1 connection '...' publication pub1 WITH(conflict_log_destination='all');

pub:
INSERT INTO tab1 VALUES ('2025-12-25 10:00:00+05:30', 1);

sub:
UPDATE tab1 SET v = 99 WHERE k = '2025-12-25 10:00:00+05:30';

pub:
DELETE FROM tab1 WHERE k = '2025-12-25 10:00:00+05:30';

sub:
--all normal so far.
SELECT (local_conflicts[1]->>'commit_ts')::timestamptz as local_ts,  
       (replica_identity->>'k')::timestamptz     as ri_ts,         
        remote_commit_ts::timestamptz as rc_ts FROM pg_conflict.pg_conflict_log_16390;




Sub:
ALTER DATABASE postgres SET DateStyle = 'SQL, DMY';
ALTER SUBSCRIPTION sub1 DISABLE; ALTER SUBSCRIPTION sub1 ENABLE;   -- restart worker

pub: insert an AMBIGUOUS date (Jan 2)

INSERT INTO tab1 VALUES ('2025-01-02 08:00:00+05:30', 1);

sub: 
UPDATE tab1 SET v=99 WHERE k='2025-01-02 08:00:00+05:30';

pub: 
DELETE FROM tab1 WHERE k='2025-01-02 08:00:00+05:30';

--let user read the CLT in an ISO,MDY session and casts both back:
--Jan 2 read as Feb 1 in ri_ts columns.
SET DateStyle='ISO, MDY';
SELECT (local_conflicts[1]->>'commit_ts')::timestamptz as local_ts,  
       (replica_identity->>'k')::timestamptz     as ri_ts,         
        remote_commit_ts::timestamptz as rc_ts FROM pg_conflict.pg_conflict_log_16390;


~~


Before fix:
postgres=# SET DateStyle='ISO, MDY';
SELECT (local_conflicts[1]->>'commit_ts')::timestamptz as local_ts,  
       (replica_identity->>'k')::timestamptz     as ri_ts,         
        remote_commit_ts::timestamptz as rc_ts FROM pg_conflict.pg_conflict_log_16390;
SET
             local_ts             |           ri_ts           |              rc_ts              
----------------------------------+---------------------------+---------------------------------
 2026-10-13 09:28:44.599098+05:30 | 2025-12-25 10:00:00+05:30 | 2026-10-13 09:28:49.77991+05:30
 2026-10-13 09:29:18.173178+05:30 | 2025-02-01 08:00:00+05:30 | 2026-10-13 09:29:23.37772+05:30
(2 rows)


After fix:
postgres=# SET DateStyle='ISO, MDY';
SELECT (local_conflicts[1]->>'commit_ts')::timestamptz as local_ts,  
       (replica_identity->>'k')::timestamptz     as ri_ts,         
        remote_commit_ts::timestamptz as rc_ts FROM pg_conflict.pg_conflict_log_16390;
SET
             local_ts             |           ri_ts           |              rc_ts               
----------------------------------+---------------------------+----------------------------------
 2026-10-13 09:21:16.31546+05:30  | 2025-12-25 10:00:00+05:30 | 2026-10-13 09:21:21.395595+05:30
 2026-10-13 09:23:28.976249+05:30 | 2025-01-02 08:00:00+05:30 | 2026-10-13 09:23:34.624595+05:30
(2 rows)