Levasseur, Fabrice fabrice.levasseur
Tue Jul 27 09:33:05 PDT 2004
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


More information about the Slony1-general mailing list