workaround request to add tables to repset if they dont have primary key #31
Replies: 1 comment 1 reply
-
You can manually add a table without a primary key using repset-add-table. Tables without a primary key cannot replicate update and delete statements |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi guys,
I have few tables without primary_key and when i try to add them to repset i had created it fails with below error. Can you please advise how to sort this out? thanks
Adding table
schema.abcdtable
to replication setabc_replication_set
.WARNING: table
abcdtable
cannot be added to replication setabc_replication_set
WARNING: DETAIL: table does not have PRIMARY KEY and given replication set is configured to replicate UPDATEs and/or DELETEs
postgres v15.3
Beta Was this translation helpful? Give feedback.
All reactions