Melvin Davidson mdavidson
Fri Apr 28 15:29:36 PDT 2006
>
>    try {
>      create set (id = 999, origin = 1, comment = 'merge set');
>      set add table (set id = 999, origin = 1, id = 999, fully qualified
>name = '$TAB');
>    }
>    wait for event( origin = all, confirmed = all, wait on = 1, timeout
>= 0);
>    echo 'Added $TAB to temporary set';
>
>    subscribe set (id = 999, provider = 1, receiver = 2, forward = no);
>    wait for event( origin = all, confirmed = all, wait on = 1, timeout
>= 0);
>    echo 'Subscribed $TAB';
>
>    merge set (id = 667, add id = 999, origin = 1);
>    wait for event( origin = all, confirmed = all, wait on = 1, timeout
>= 0);
>    echo 'Merged $TAB';

If you are going to use a variable for a table name, _do not_ enclose it in quotes.
In your case, slony is now looking for a table named $TAB.

The correct statement should be
set add table (set id = 999, origin = 1, id = 999, fully qualified name = $TAB);

Good luck, and may the bytes be with you. 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: mdavidson.vcf
Type: text/x-vcard
Size: 300 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060428/b86c9ab2/mdavidson.vcf



More information about the Slony1-general mailing list