Re: PostgreSQL 16 bug feedback

On Thursday, July 17, 2025, yexiu-glory <yexiu-glory(at)qq(dot)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.