Hello Samantha,
 
from the documentation:
[...]
ID = ival 

ID of the set to subscribe

[...]
 
Just try it this way:
 
        subscribe set ( id = 1, PROVIDER = 1, receiver = 2, forward = no );

Regards,
Sascha
 
IZB Informatikzentrum 
M?nchen - Frankfurt am Main GmbH & Co.KG 
Einsteinring 17 
85609 Aschheim 
 <http://www.izb.net/> www.izb.net 

Ein Unternehmen der Sparkassen Finanzgruppe. 

--------------------------------------------------------------- 
Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte 
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail 
irrt?mlich erhalten haben, informieren Sie bitte sofort den Absender und 
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte 
Weitergabe dieser Mail ist nicht gestattet. 
--------------------------------------------------------------- 
This e-mail may contain confidential and/or privileged information. If you 
are not the intended recipient (or have received this e-mail in error) 
please notify the sender immediately and destroy this e-mail. 
Any unauthorized copying, disclosure or distribution of the material in 
this e-mail is strictly forbidden. 
--------------------------------------------------------------- 
IZB Informatik-Zentrum M?nchen-Frankfurt 

-----Urspr?ngliche Nachricht-----
Von: slony1-general-bounces at gborg.postgresql.org
[mailto:slony1-general-bounces at gborg.postgresql.org] Im Auftrag von Samantha
Surendran
Gesendet: Donnerstag, 25. Januar 2007 06:48
An: slony1-general at gborg.postgresql.org
Betreff: [Slony1-general] Error while creating second set


Hi,
 
I am trying to create a second set and then do a merge onto the first one.
The create set and set add table went through fine. But the subscribe set
failed. 
 
 
this is my script, which contains only the subcribe set
 
#/bin/bash
 
slonik <<_EOF_ 2>> /usr/local/pgsql/slony_setup.log 1>>
/usr/local/pgsql/slony_setup.log
        cluster name = was1_;
    node 1 admin conninfo = 'dbname=wasdb3 host=xxxx port=5432 user=postgres
password=xyz';
        node 2 admin conninfo = 'dbname=wasdb3 host=yyyy port=5432
user=postgres password=xyz';
 
        subscribe set ( id = 2, PROVIDER = 1, receiver = 2, forward = no );
_EOF_
 
if [ $? -ne 0 ]
then
    echo Errors were detected.  Please review
/usr/local/pgsql/slony_setup.log and fix the errors.
    exit -1
fi
 
echo The script has succeeded.  At this time the slaves should be receiving
the data
echo from the master.

 
I still receive this error on running this script.
<stdin>:5: PGRES_FATAL_ERROR select "_was1_".subscribeSet(2, 1, 2, 'f');  -
ERROR:  Slony-I: set 2 not found
 


Has anyone faced this error before. Can someone please help?

 
Regards,
Samantha
 
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient,
please notify the sender by e-mail and delete the original message. Further,
you are not to copy, disclose, or distribute this e-mail or its contents to
any other person and any such actions are unlawful. This e-mail may contain
viruses. Infosys has taken every reasonable precaution to minimize this
risk, but is not liable for any damage you may sustain as a result of any
virus in this e-mail. You should carry out your own virus checks before
opening the e-mail or attachment. Infosys reserves the right to monitor and
review the content of all messages sent to or from this e-mail address.
Messages sent to or from this e-mail address may be stored on the Infosys
e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20070125/f10a091f/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Spreitzer, Sascha.vcf
Type: application/octet-stream
Size: 366 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20070125/f10a091f/attachment-0001.obj