1.概述
PostgreSQL进行修改的时候就出现了:cannot update table "home" because it does not have a replica identity and publishes updates
2.场景1
我们最近风风烈烈的做了MySQL转PostgreSQL项目运动,然后改完自测完毕后,过了很久突然报错这个。
在进行修改的时候就出现了:cannot update table "home" because it does not have a replica identity and publishes updates
开始以为是自己代码问题,后来手动执行也报错
update xxx set "disable" = false where id =1;