-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

marco perugini a écrit :
> hi list!
> i'm going to replicate a db which has triggers and stored procedures
> that replicate some insert to another db;
> so this is my question for you: if i insert a raw in a triggered-table
> on masterdb does the slavedb repeat the trigger? [i made "pg_dump -s" to
> replicate the schema to the slavedb]
> i've to delete the trigger on the slavedb to avoid the "undesired double"?
> 
> 
> masterdb --> otherdb [original trigger] --> that's right!
>     |
>     |
>     |
>    V
> slavedb --> otherdb [replicated trigger] --> i don't want this!!
> 
> thanks a lot for your feedback and i'm sorry for my bad english..
> marco

Hi,

Slony does deactivate already existing triggers on the slave.

SAS
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJgbwZA+REPKWGI0ERAqwfAJ9NusMTB7GXaCFoZstdiMG68xgSfQCg0IYb
Fu7nW8KOKxxnn14VSJVgcu4=
=3KZx
-----END PGP SIGNATURE-----