Slony1 PostgreSQL Replication - "wait on" option of WAIT FOR EVENT

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

"wait on" option of WAIT FOR EVENT

Henrique Engelmann

2006-02-06, 9:24 am

Hi,

With the following slonik commands I would like to move set 1 from node2 to node 1 again but I´ve some doubts about the "wait on" option of the WAIT FOR EVENT command.

lock set (id = 1, origin = 2);
wait for event (origin = 2, confirmed = 1);
move set (id = 1, old origin = 2, new origin = 1);
wait for event (origin = 2, confirmed = 1);

What it really means?
When should it be used?

Thanks in advance!

Engelmann

____________________
____________________
__________
Faça ligações para outros computadores com o novo Yahoo! Messenger
http://br.beta.messenger.yahoo.com/

Sponsored Links