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
ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab