On Thu, 2025-07-17 at 19:41 +0800, yexiu-glory 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.
That's not a bug.
To make that replication work, you must have excluded the column "phone" from
the list of published columns. So it cannot be a part of the replica identity,
the set of columns used in the WHERE condition on the subscriber.
Stick with REPLICA IDENTITY DEFAULT.
Yours,
Laurenz Albe
