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
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
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.abcdtableto replication setabc_replication_set.WARNING: table
abcdtablecannot be added to replication setabc_replication_setWARNING: 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