表没有主键 - 做了逻辑复制 - 触发了这个报错 

Store delete error
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [UPDATE kx_kq_channelinventorydetail
SET platstatus = ?, platupdateop = ?, platupdatetime  = ?
WHERE (id = ? AND platstatus = 1)]; SQL state [55000]; error code [0]; ERROR: cannot update table "kx_kq_channelinventorydetail" because it does not have a replica identity and publishes updates
  Hint: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.; nested exception is org.postgresql.util.PSQLException: ERROR: cannot update table "kx_kq_channelinventorydetail" because it does not have a replica identity and publishes updates
  Hint: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(

 

posted @ 2021-10-14 15:27  littlevigra  阅读(585)  评论(0)  编辑  收藏  举报