On Tuesday 27 March 2007 17:45, Steve Singer <ssinger_pg at sympatico.ca> 
wrote:
> On Tue, 27 Mar 2007, Alan Hodgson wrote:
>
> I don't know what workarounds are going to be options for you compared
> with running a patched version of slony but if you
> need a fix right away you could consider patching your version of slony.
>
> The patched attached to
> http://lists.slony.info/pipermail/slony1-patches/2007-March/000005.html
>
> should address the problem your describing.  I assume it will be
> included with the next 1.2.x release.
>

Thank you for that. I will test it and consider running with it for now.  
However, I actually think the intended behaviour for 1.2 is correct - 
DDL scripts should execute on all nodes (working around the 1.1 
behaviour was also quite tedious).  It just isn't working correctly ... 
and I can't see why.  

I was poking around the slon code last night, and it really looks like 
it should be altering all the same tables before and after the DDL 
script is run, but the error I'm getting seems to imply that either 
alterTableRestore is not being run on some tables or  
alterTableForReplication is somehow being run twice.

And actually, now that I think about it, neither should be run on tables 
that aren't actually replicated on this node.  Hrmm ... I can probably 
manage to find and fix that.

-- 
"Government big enough to supply everything you need is big enough to
take everything you have ... the course of history shows that as a
government grows, liberty decreases." -- Thomas Jefferson