marco perugini m.perugini at 4it.it
Thu Jan 29 04:17:01 PST 2009
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


More information about the Slony1-general mailing list