pgsql数据库报错:because it does not have a replica identity and publishes updates

SQL 错误 [55000]: ERROR: cannot delete from table "xxxxx" because it does not have a replica identity and publishes updates。SQL 错误 [55000]: ERROR: cannot delete from table "xxxxx" because it does not ha

ccoolclouds

779人浏览 · 2024-05-21 08:46:55

ccoolclouds · 2024-05-21 08:46:55 发布

SQL 错误 [55000]: ERROR: cannot delete from table "xxxxx" because it does not have a replica identity and publishes updates
Hint: To enable updating from the table, set REPLICA IDENTITY using ALTER TABLE.

SQL 错误 [55000]: ERROR: cannot delete from table "xxxxx" because it does not have a replica identity and publishes deletes
Hint: To enable deleting from the table, set REPLICA IDENTITY using ALTER TABLE.

ALTER TABLE xmgl REPLICA IDENTITY FULL;