xca icon indicating copy to clipboard operation
xca copied to clipboard

primary keys

Open vladojr opened this issue 2 years ago • 1 comments

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

vladojr avatar Dec 29 '21 07:12 vladojr

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.

exabrial avatar Oct 04 '22 14:10 exabrial