On Tue, Apr 26, 2011 at 11:07 AM, Steve Singer <[email protected]> wrote: > 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.
Yep, "what Steve said." In version 2, it might become a reasonable proposition to drop the triggers directly, but on 1.2, Slony does way too much mucking around with the system catalog for it to seem remotely safe to do other than EXECUTE SCRIPT. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
