On Friday, May 28, 2021 6:51 PM, Dilip Kumar <dilipbalaut@gmail.com> wrote:
> Seems you did not set the replica identity for updating the tuple.
> Try this before updating, and it should work.
Thanks for your reply. I tried it.
> ALTER TABLE toasted_key REPLICA IDENTITY USING INDEX toasted_key_pkey;
This didn't work.
> or
>
> ALTER TABLE toasted_key REPLICA IDENTITY FULL.
It worked.
And I noticed if the length of PRIMARY KEY (toasted_key) is short, data could be synchronized successfully with default
replicaidentity.
Could you tell me why we need to set replica identity?
Regards
Tang