Slony1 PostgreSQL Replication - Composite primary keys supported?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Composite primary keys supported?

Michael Ulitskiy

2006-02-03, 8:24 pm

Hello,
In a set I need to replicate there are severable tables that have
composite primary keys, i.e. primary keys over several fields.
Is it supported by Slony-I or I still have to add serial column?
The documentation says: "every replicated table is required to have at
least one UNIQUE constraint whose columns are declared NOT NULL.
Any primary key satisfies this requirement", but somehow I'm not sure
about it.
Can please someone confirm that composite primary keys are supported?
Thank you,
Michael

Sponsored Links