Apache Doris 中文技术论坛
Questions Tags Users Badges

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

Asked Sep 12, 2024 Modified Jan 1, 0001
Viewed 36
2.1

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

edited Jan 1, 0001
Jack9
asked Sep 12, 2024
1 Answers

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

edited Sep 13, 2024
徐振超@SelectDB8151
answered Sep 13, 2024
Related Questions
AUTO LIST PARTITION 分区名长度为何限制 50?能否配置放宽/取消?
doris2.1.11重复建表报错内容异常,不会提示表已经存在
1 answers
我们通过hive catalog外表同步数据,有时候hive表会很大导致内存占满了会杀掉其他任务,限制内存又会导致同步任务失败,有什么方法可以稳定一下呢,同步效率慢一点什么的也没问题
1 answers
doris be启动报错
2 answers
Doris的json解析问题
1 answers
doris-2.1.11使用flink同步数据,有时间转换jar包冲突
2 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.