PostgreSQL 报错 because it does not have a replica identity and publishes updates

本文主要是介绍PostgreSQL 报错 because it does not have a replica identity and publishes updates，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

(update,delete触发,insert不触发)because it does not have a replica identity and publishes updates

Hint: To enable updating from the table, set REPLICA IDENTITY using ALTER TABLE

如果相关表涉及了逻辑复制，且对应表没有主键，则需要SET REPLICA IDENTITY(alter table xxx replica identity full),

集成任务的复制槽可以查询pg_replication_slots,发布可以查询pg_publication，发布的表可以查pg_publication_tables。

REPLICA IDENTITY：default,full,index indexname,nothing，通过pg_class的字段relreplident可以获取

添加发布表: alter publication pubname add table tablename; —反之是drop,publication也支持disable和enable

这篇关于PostgreSQL 报错 because it does not have a replica identity and publishes updates的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---