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... _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
