Re: Proposal: Conflict log history table for Logical Replication

[Dilip Kumar]

On Thu, Oct 15, 2026 at 9:47 AM shveta malik <shveta.ma...@gmail.com> wrote:
>
> On Wed, Oct 14, 2026 at 8:16 PM Nisha Moond <nisha.moond...@gmail.com> wrote:
> >
> >
> > 1) Does the remote_origin column in CLT add any value?
> >   + if (replorigin_xact_state.origin != InvalidReplOriginId)
> >   + replorigin_by_oid(replorigin_xact_state.origin, true, &remote_origin);
> >
> > IIUC, replorigin_xact_state.origin is the subscription's own origin,
> > set at worker start, so every row has pg_<subid>.
>
> It could also be pg_<subid>_<relid>, for a tablesync worker. But
> again, it is not very useful as both subid and relid can be figured
> out from CLT table itself. So I too currently do not see any use of
> this column, unless I am missing some case?
>

Yeah, that's a valid point, we can remove this column for now.  We do
not have such a column in the log either.  Lets see what Amit says on
this then I can remove this field.

-- 
Regards,
Dilip Kumar
Google