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