On Friday, May 28, 2021 6:51 PM, Dilip Kumar <dilipbal...@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 replica identity. Could you tell me why we need to set replica identity? Regards Tang
