On 04/14/2014 08:37 AM, Sebastian Pawłowski wrote:
> hi,
>
> Slony 2.2.2 no longer accepts SET ID as a valid option, what if I’m
> replicating sets with different tables and some set is not being
> replicated to some nodes? What if I want to make some DDL changes to
> these tables? In the earlier version DDL changes was replicated only to
> proper nodes, and now to all nodes.
>
> I know I may make DDL changes directly, but with execute script was
> easier, is there any better way for making ddl changes in such situations?
>
> -------

You can actually pass a list to EXECUTE SCRIPT in the ONLY ON option

Ie

execute script(event node=2, SQL='CREATE TABLE bar(a int4);', execute 
only on='2,3,4');


(Though this doesn't appear to be documented, I should fix that)



> sebpa
>
>
>
>
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>