>Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> FWIW, I find the ability in Slony to configure triggers so they work
> or not depending on the replication role to be extremely useful.
> Absolutely a major positive feature.
Yeah, as a general rule it doesn't make sense to try to enforce
constraints on a replication *target*. Check and report, perhaps, but
you don't normally want to error out on anything which you know was
actually applied to the source database. It's even worse for some
classes of triggers which generate derived data; you don't want the
replication to generate one value and then a trigger on the
replication target to try to do the same. A count, for example, could
easily wind up with an "off by one" error much of the time.
-Kevin