Jeff Davis pgsql
Fri Sep 29 11:41:38 PDT 2006
I am confused about how slonik commands are grouped.

If several commands are grouped together in a try {}, that's supposed to
be a transaction. But if I do a "lock set" in a try where a command
fails, the set is still locked afterward.

What is the difference between:

* slonik commands issued in different invocations of slonik
* slonik commands issued in the same invocation of slonik
* slonik commands issued in a try in an invocation of slonik

I am particularly confused when it comes to "move set" and "unlock set".
If I lock the set, then move the set, then I think it's already
unlocked. And I can't find a way to issue an unlock after a move set
because neither value for the origin seems valid.

Under what circumstances should I use move set?

Regards,
	Jeff Davis






More information about the Slony1-general mailing list