Configured pglogical source is 9.4 target is 12.3
a table has PK from multiple column (varchar(50),char(2),char(1)).
initial syncronization is OK, but when at source there is delete , but got
error at target...
LOG: CONFLICT: remote DELETE on relation public.a_XXXX replica identity
index a_XXX_pk (tuple not found). Resolution: skip.
replica identity was set to default for the table so yes there is old image
on those 3 columns:
but why delete was error at target?
collation exactly same on all GUC.
any direction to print debug verbosity on why delete on target didnt find
row and skipped?
--
regards
ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab