Fri Apr 28 15:29:36 PDT 2006
- Previous message: [Slony1-general] Slony1 + reiser + Suse logfile size
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>
> 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
- Previous message: [Slony1-general] Slony1 + reiser + Suse logfile size
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list