Slony1 PostgreSQL Replication - Re: 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

Re: Composite primary keys supported?

Christopher Browne

2006-02-03, 8:24 pm

Michael Ulitskiy wrote:

>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,
>
>
Yes, we are using composite primary keys for numerous replicated "link
tables."

Definitely supported. I'll make that more explicit in the "defining
sets" documentation...

Sponsored Links