Hi All,


I am trying to replicate DB in Windows VISTA using PgadminIII, Postgres
8.3.7 and Slony 1.2.16. I am not using Slonik scripts.
Although the tables in my replication set have unique ids,
when i start the service for replication, slony-I tries to execute the
command - 

select "_M_Cluster".setAddTable_int(1, 1, '"nlp_schema"."authority"',
'authority_pkey', ''); 

in the console and return with this error given below. 

2009-08-04 10:45:53 GMT Daylight Time ERROR
remoteWorkerThread_1:"select "_M_Cluster".setAddTable_int(1, 1,
'"nlp_schema"."authority"',
'authority_pkey', ''); " PGRES_FATAL_ERROR ERROR:Slony-I:
setAddTable_int: table id 1 has already been assigned!


I tried searching for the same error in slony-I documentation which says
that this error can
Occur if the primary key are not been defined as NOT NULL which I have. 
Please let me know how to resolve this issue.


Regards,
Don


Intelligent Addressing Ltd. Registered Office: 1 Adam Street, London WC2N 6DD Reg. in England No.3863861 VAT No.GB 802258946

This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com