PostgreSQL数据库从入门到精通系列之十六:cannot delete from table...because it does not have a replica identity
一、完整报错
- SQL 错误 [55000]: ERROR: cannot delete from table “gp_measurement_y2024m07” because it does not have a replica identity and publishes deletes
建议:To enable deleting from the table, set REPLICA IDENTITY using ALTER TABLE.
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:509)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda 0 ( S Q