本文主要是介绍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的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
