PG 开启逻辑解码要求wal_level = logical后数据库表更新报错

Question

SQL Error [55000]: ERROR: cannot delete from table "test_delete" because it does not have a replica identity and publishes deletes Hint: To enable deleting from the table, set REPLICA IDENTITY using ALTER TABLE.
PG 13
Doris 2.1.5
flink 1.19
Flink-CDC 3.1.1

徐振超@SelectDB · Accepted Answer

这块应该是pg的问题，参考链接：
https://stackoverflow.com/questions/49257365/unable-to-delete-from-a-temp-table

PG 开启逻辑解码要求wal_level >= logical后数据库表更新报错

1 Answers