Hi

I do the following

create databases db1, db2 and put some data in db1
set up replication from db1 to db2
move origin from db1 to db2
create database db3 and set it to replicate from db2
set db2 subscription to forward=yes
create database db4 and set it to replicate from db3

all but the last step work fine but no replication starts for db4
and nothing suspicious in the logs (I think ;)

after I start and stop all slon's, I get the following in db4 slon log:

 ERROR  remoteWorkerThread_2: "select
"_db_cluster".sequenceSetValue(1001,2,'61','3'); " PGRES_FATAL_ERROR
ERROR:  Slony-I: sequence 1001 not found

what am I doing wrong ?

the scripts to test this are attached:

-------------- next part --------------
A non-text attachment was scrubbed...
Name: reptest.tgz
Type: application/binary
Size: 2192 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20040928/204e463d/reptest.bin