Christopher Browne cbbrowne
Fri Feb 3 12:44:46 PST 2006
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...



More information about the Slony1-general mailing list