Tue Jul 27 09:33:05 PDT 2004
- Previous message: [Slony1-general] Primary key with two columns ?
- Next message: [Slony1-general] Primary key with two columns ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, Slony add a specific column with a "slony primary key" inside all tables. So you don't need to update your database. Exemple: ident | nom | latitude | longitude | _Slony-I_test1_rowID ----------+---------+----------+-----------+---------------------- 00000000 | POINT00 | | | 1000000000021188 00000001 | POINT01 | | | 1000000000021189 00000002 | POINT02 | | | 1000000000021190 00000003 | POINT03 | | | 1000000000021191 00000004 | POINT04 | | | 1000000000021192 00000005 | POINT05 | | | 1000000000021193 Fabrice Levasseur ************************************************** SIGMA Project EDS Answare www.eds.com / www.eds.fr ************************************************** -----Message d'origine----- De : slony1-general-bounces at gborg.postgresql.org [mailto:slony1-general-bounces at gborg.postgresql.org]De la part de Herv? Piedvache Envoy? : mardi 27 juillet 2004 11:08 ? : slony1-general at gborg.postgresql.org Objet : [Slony1-general] Primary key with two columns ? Hi, Just a small question, I'm working to update a database "to be" slony compatible ... I know that all my tables wich need to be replicated need a primary key ... but does Slony is able to manage a primary key with two fields ? Like this : alter table panel add primary key (idmember, panel_name); Thanks per advance for the answer ... Regards, -- Herv? Piedvache Elma Ing?nierie Informatique 6 rue du Faubourg Saint-Honor? F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902 _______________________________________________ Slony1-general mailing list Slony1-general at gborg.postgresql.org http://gborg.postgresql.org/mailman/listinfo/slony1-general
- Previous message: [Slony1-general] Primary key with two columns ?
- Next message: [Slony1-general] Primary key with two columns ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list