Hi, I was wondering if it is possible to define multiple primary keys in the set add table function.
Like so: set add table ( set id = 1, origin = 1, id = 54, full qualified name = 'public,foo_map, key = 'foo1,foo2', comment = 'Table foo_map'); Table: ----------- CREATE TABLE foo_map ( customer integer NOT NULL, address integer NOT NULL ); Primary key(s): ------------------------ ALTER TABLE ONLY foo_map ADD CONSTRAINT foo_map_pkey PRIMARY KEY (foo1, foo2); Table foo1/foo2: -------------------------- CREATE TABLE foo1 ( id integer NOT NULL, first_name character varying(255), last_name character varying(50), created_date timestamp without time zone, modified_date timestamp without time zone, enabled boolean ); CREATE TABLE foo2 ( id integer NOT NULL, address character varying(50), created_date timestamp without time zone, modified_date timestamp without time zone, enabled boolean ); Don`t ask my why I need this because it isn`t my database design. Personally I see no use in multiple primary keys defined for one table. Well let me know Thanks in advance With kind regards Matthew Whittaker-Williams -- Unix system & Network Engineer Internet Unie Services B.V. Postbus 23667 1100 ED AMSTERDAM Tel: +31(0)20 463 0506 Fax: +31(0)20 463 2146 Email: [EMAIL PROTECTED] URL: http://iu.nl PGP: 0x08A909D0 Ripe nic-handle: MW2861-RIPE _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
