On Sat, 2006-12-09 at 18:07 +0100, Andreas Kostyrka wrote:
> Actually, in practice I've discovered that one almost never needs to
> use a generic EXECUTE SCRIPT to apply ALTER TABLE statements. Wonder
> if anyone else might be interested in the rules that I derived.
> 
> E.g. 
> 
> Add column can always be done without slony help.

This is false.  It may work sometimes, or even most of the time, but it
doesn't work all the time.  I have seen first hand replication break by
adding a column to a table directly (and yes, the changes were
consistent across all nodes).  Sorry, I forget the exact details,  it
was a while ago.  I know that fixing things involved manually cleaning
out events and the fixing the broken triggers by manually running the
slony functions that alter the tables.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.