* Andreas Kretschmer <[EMAIL PROTECTED]> [061123 13:55]:
> Pradeep Parmar <[EMAIL PROTECTED]> schrieb:
>
> > Hi,
> >
> > I was trying setting up slony on two diff. nodes. Node A as master server
> > and
> > Node B as slave
> > Database has just two tables , one of the tables doesn't has a primary key
> > so i
> > have used the table add key in the slonik commands script. I'm getting the
> > below error
> >
> >
> > <stdin>:7: PGRES_FATAL_ERROR select "_slash".determineIdxnameUnique
> > ('public.staff', NULL); - ERROR: Slony-I: table "public"."staff" has no
> > primary key
>
> You need a primary key on each replicated table. If you haven't a
> primary key, you *must* add one. You can use slonik for this:
>
> table add key (node id = 1, fully qualified name = 'public.staff');
Although in the practice, it's way less painful to have an application
level key added. table add key generated keys tend to be painful when
it comes to backups.
Andreas
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
