On Sun, Apr 22, 2007 at 08:27:27PM -0700, Andrew Hammond wrote:
> 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.
And a _really_ nifty trick is that you can STORE TRIGGER _before the
trigger is installed_. This means if you want to add a trigger to
all nodes, and don't want to take the outage right away (because of a
lock on the table you're adding it to), you could STORE TRIGGER and
then add the relevant trigger to the origin node when you have your
next outage (just don't forget!)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
