does Slony deactivate already existing triggers on the master also? this should be a problem.. :(
thnaks a lot! m. Stéphane A. Schildknecht ha scritto:
-----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.. marcoHi, 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-----
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
