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
