On Thursday, July 17, 2025, yexiu-glory <yexiu-gl...@qq.com> wrote: > I encountered a problem in PostgreSQL 16: > In db1, there is a user table with fields id, name, phone, and createtime > db2 replicates the user table from db1 through logical replication, > specifying the fields as id, name, and createtime > Then, in db1, perform the following operation: alter table user replica > identity full; > Then, modifying or deleting a record in the user table will result in an > error, > The error message for modification is as follows, and similar errors also > occur when deleting. > update "public"."user" set name='aaa’where id = 20005 > >ERROR: cannot update table "user"DETAIL: Column list used by the > publication does not cover the replica identity. >
What did you expect to happen? David J.
