And could someone please mark in FAT RED LETTERS (all caps please) that
"wait for event" does not work for "subscribe" and that an immediately
following "merge" cannot and will not work. The event to wait for before
executing the "merge" is the ENABLE_SUBSCRIPTION created by the set
origin when processing the SUBSCRIBE_SET. Slonik at this time has no
clue when that even might happen. The only way to do it is to split the
whole work into two slonik scripts and wait with other mechanisms until
the newly subscribed tables actually appear in the subscribers sl_table
config.
For some reason almost everyone trying to add new tables stumbles over
that problem. I presume our documentation is lacking here.
Jan
On 4/28/2006 6:29 PM, Melvin Davidson wrote:
>>
>> 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.
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Slony1-general mailing list
> [email protected]
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== [EMAIL PROTECTED] #
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
