xca
xca copied to clipboard
primary keys
Hello, to enable database replication i need to provide a primary key for each table. Can you please provide code to setup primary keys for each table? If there are tables without obvious key, can it be added (with a default value) without breaking xca functionality? Im using postgres. Thank you
You can simply add an auto-generated PK to each table by modifying the schema and this should solve your issue in the short term.