does Slony deactivate already existing triggers on the master also? this sh=
ould be a problem.. :(

thnaks a lot!
m.





St=E9phane A. Schildknecht ha scritto:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> marco perugini a =E9crit :
>   =

>> 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=3D
> =3D3KZx
> -----END PGP SIGNATURE-----
>
>
>   =



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090130/=
2122db51/attachment.htm