On Wed, Feb 22, 2006 at 05:02:38PM -0700, Rick Gigger wrote:

> you are replicating to a database with different table definitions.   
> What if the statements to be replicated are now invalid on the slave  
> but valid on the master.  What happens then?

Things break really badly.  You _must_ use execute.

> the foot.  It would be nice to be able to just update the master to  
> your hearts content have the slaves get updated as well.

Well, unless you _want_ the differences on the origin and replica. 
Remember, that's also a feature.  You could replicate to a target
that looks slightly different, so that some tables can show up on the
target but not others.  It's important not to think of "master
database".  I can see the argument per-table, but you need to be able
to turn it off.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism. 
                --Brad Holland