hum ... it's quite better to manage by yourself the primary key on your 
tables ... you may need them in most of time ... more than Slony ;o)

regards,

Le mardi 27 Juillet 2004 11:31, Levasseur, Fabrice a ?crit :
> 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