On 11-04-26 10:59 AM, Frank McGeough wrote: > > Steve, > > The drop table on table "B" worked fine. The problem that I have is that the > trigger is on table "A" - which is still replicated. > > To state the question as generally as I can : how do you drop triggers within > a Slony replicated system? There are always cases where you realize a trigger > on a replicated table is no longer needed. What do you do in that case? What > is the Slony prescribed procedure for dealing with that?
To drop a non-slony installed trigger on a replicated table in 1.2 you use EXECUTE SCRIPT. When the EXECUTE SCRIPT command/event runs on the slave it will restore all replicated tables to the unaltered state for the duration of the script. Keep in mind that EXECUTE SCRIPT in 1.2 is a heavy locking operation. > > > Thanks, > Frank > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
