Hello all,

I am using slony1 1.2.16-1 on CentOS 5 and my postgres version is 8.1.11 .

Few tables in my database do not have a PRIMARY KEY.

 PGRES_FATAL_ERROR select
"_replcluster".determineIdxnameUnique('public.t_history', NULL);  - ERROR:
Slony-I: table "public"."t_history" has no primary key


Also few tables in the db have FOREIGN KEY.

PGRES_FATAL_ERROR select
"_replcluster".determineIdxnameUnique('public.t_r_off_hol_cash', NULL);  -
ERROR:  Slony-I: table "public"."t_r_off_hol_cash" has no primary key


Another problem is that few tables have combination of keys as PRIMARY KEY.

 PGRES_FATAL_ERROR select "_replcluster".setAddTable(2, 2,
'public.t_emp_leave', 'emp_leave_pk', 'parent table');  - ERROR:  Slony-I:
setAddTable(): set 2 not found


Is there any way in which slony can still replicate .. I mean without
primary keys???

If not then is there any other way???   (I cannot change the db structure ).

Thankyou in advance.

Regards,
 Sweta.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090804/=
cf929264/attachment-0001.htm