> It looks to me that the problem with your script is that your syntax
> here is wrong:
>
> set add table ( set id = $TEMP_SET_ID, origin = 1, id = 111, full
> qualified name = 'public.foo' );
>    set add table ( set id = $TEMP_SET_ID, origin = 1, id = 112, full
> qualified name = 'public.bar' );
>
> It's not "full qualified name". It's "fully qualified name".

Actually, both syntaxes are legitimate, accepted by the slonik parser.

Originally, the parser used the phrase "full qualified name"; the word
"fully" is more appropriate, so I added that to slonik's lexicon.

> Your script was probably just telling you 'failure', but I'll bet that
> there were some messages about
> your syntax error in the slony logs.

Seeing the exact error messages would be handy; if it had been a parser
error, that would lead to the entire script being rejected.  The try block
wouldn't fail; it would never get attempted.