On 23.05.24 08:36, shveta malik wrote:
> Conflict Resolution
> ----------------
> a) latest_timestamp_wins: The change with later commit timestamp wins.
> b) earliest_timestamp_wins: The change with earlier commit timestamp wins.
> c) apply: Always apply the remote change.
> d) skip: Remote change is skipped.
> e) error: Error out on conflict. Replication is stopped, manual
> action is needed.
You might be aware of pglogical, which has similar conflict resolution
modes, but they appear to be spelled a bit different. It might be worth
reviewing this, so that we don't unnecessarily introduce differences.
https://github.com/2ndquadrant/pglogical?tab=readme-ov-file#conflicts
There might also be other inspiration to be found related to this in
pglogical documentation or code.