报错信息:

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.

1 在数据库执行以下sql就行了:

ALTER TABLE xxxxx REPLICA IDENTITY FULL;

2 或者指定一个字段作为主键