On Mon, Jul 28, 2008 at 1:21 PM, chris <cbbrowne at ca.afilias.info> wrote:
> "Jaime Casanova" <jcasanov at systemguards.com.ec> writes:
>> Is the example in this page
>> (http://lists.slony.info/documentation/stmtmergeset.html) right? it
>> seems not to me...
>> or am i missing something?
>
> Nothing is leaping out at me as being wrong.
>
> What do you think is wrong about it?


-- CODE MODE ON --
     # Assuming that set 1 has direct subscribers 2 and 3
     SUBSCRIBE SET (ID = 999, PROVIDER = 1, RECEIVER = 2);
     SYNC (ID=1);
     WAIT FOR EVENT (ORIGIN = 1, CONFIRMED = 2, WAIT FOR=1);
     SUBSCRIBE SET (ID = 999, PROVIDER = 1, RECEIVER = 3);
     SYNC (ID=1);
     WAIT FOR EVENT (ORIGIN = 1, CONFIRMED = 3, WAIT FOR=1);
     MERGE SET ( ID = 1, ADD ID = 999, ORIGIN = 1 );
-- CODE MODE OFF --

first WAIT FOR, shouldn't be WAIT ON?
second, what's the idea of merging the same set (ID=999)? is the idea
of this example a merge between nodes?




-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157