On 4/20/07, Christopher Browne <[EMAIL PROTECTED]> wrote:
Stéphane Schildknecht <[EMAIL PROTECTED]> writes: > Good morning every body, > > I do have to create triggers on the master node. I also want to create > thoses triggers on avery suscriber as I may need one day to switch a > master and its subscriber. > > But, I don't want triggers to be activated on the subscriber nodes. > > Will the slonik execute_script be kind enough to install triggers on > every nodes without activating them ? execute script is indeed the right way to go; what happens on each subscriber is thus: - first, it takes the Slony-I triggers off tables, and restores any hidden triggers (e.g. - RI triggers and such) - then it runs your DDL script, which presumably involves adding some additional trigger. - at the end, it hides RI triggers, as well as your newly added trigger, and then adds back the "deny access" trigger. After all that, the new trigger you added will indeed be hidden, as I think you wanted.
In case there are any people who come upon this thread searching the mailing list for related topics, to unhide triggers on your replica, you'd need to run the store trigger command via slonik. Andrew
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
