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 > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
