Hervé Piedvache herve
Tue Jul 27 16:49:55 PDT 2004
OK perfect ... Thanks Jan ! ;o)

Le mardi 27 Juillet 2004 16:05, Jan Wieck a ?crit :
> On 7/27/2004 5:31 AM, Levasseur, Fabrice wrote:
> > Hi,
> >
> > Slony add a specific column with a "slony primary key" inside all tables.
> > So you don't need to update your database.
>
> This is wrong.
>
> The primary key added by slony is only meant as an interims solution for
> tables that don't have a natural primary key. Using the real primary key
> for row identification is recommended and I encourage Herv? to prepare
> the DB schema in that direction.
>
> Multi-column primary keys are supported and the given example in the
> original mail is perfectly fine.
>
>
> Jan
>
> > 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


More information about the Slony1-general mailing list