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 | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
