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.
begin:vcard
fn:Melvin Davidson
n:Davidson;Melvin
org:Computer & Communication Technologies
adr;dom:;;6 Inverness Ct. East;Englewood;CO;80112
email;internet:[EMAIL PROTECTED]
title:Database Developer
tel;work:303-708-9228 ext. 305
x-mozilla-html:TRUE
url:http://www.cctus.com
version:2.1
end:vcard
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
