Fri Feb 3 12:44:46 PST 2006
- Previous message: [Slony1-general] Composite primary keys supported?
- Next message: [Slony1-general] "wait on" option of WAIT FOR EVENT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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...
- Previous message: [Slony1-general] Composite primary keys supported?
- Next message: [Slony1-general] "wait on" option of WAIT FOR EVENT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list