Re: PostgreSQL 16 bug feedback

On Thursday, July 17, 2025, yexiu-glory <yexiu-glory@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?

I think it would be better if, when using the command "alter table user replica identity full" and specifying columns, the full-state synchronization should also synchronize all the specified fields?