Hi Guys,
I was just taking a look at the changes to lockset() between 2.0 and 2.1 and
noticed it now uses a lock on the row in sl_set rather than a table lock on
sl_config_lock.
I was wondering, does this now make it possible to do something along the lines
of:
TRY {
LOCK SET ( ID = 1, ORIGIN = 1);
LOCK SET ( ID = 2, ORIGIN = 1);
}
ON ERROR ( blah }
MOVE SET ( ID = 1, OLD ORIGIN = 1, NEW ORIGIN = 2);
WAIT FOR EVENT (ORIGIN = 1, CONFIRMED = ALL, WAIT ON = 1, TIMEOUT = 0);
MOVE SET ( ID = 2, OLD ORIGIN = 1, NEW ORIGIN = 2);
WAIT FOR EVENT (ORIGIN = 1, CONFIRMED = ALL, WAIT ON = 1, TIMEOUT = 0);
(Or even wrap the move sets in a try too?)
The reason I ask is we're currently using 2.0.7 and when we move a bunch of
sets between nodes it'd be ideal if they were all locked before they were moved.
Sorry if I've got the wrong end of the stick here, or this has already been
answered somewhere, I did do a good search before posting!
Thanks
Glyn_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
