<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div><span>Great, try to keep the messages on the mailing list.</span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Riya V <riyav@hotmail.com><br> <b><span style="font-weight: bold;">To:</span></b> glynastill@yahoo.co.uk <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, 6 June 2012, 18:12<br> <b><span style="font-weight: bold;">Subject:</span></b> RE: [Slony1-general] creating a new trigger for a table on a slave
host<br> </font> </div> <br><div id="yiv929955892">
<style><!--
#yiv929955892 .yiv929955892hmmessage P
{
margin:0px;padding:0px;}
#yiv929955892 body.yiv929955892hmmessage
{
font-size:10pt;font-family:Tahoma;}
--></style>
<div><div dir="ltr">
Thanks!<div>We are on 1.2 now and planning to move to 2.X</div><div><br></div><div>Riya<br><br><div><div id="yiv929955892SkyDrivePlaceholder"></div><hr id="yiv929955892stopSpelling">Date: Wed, 6 Jun 2012 12:19:02 +0100<br>From: glynastill@yahoo.co.uk<br>Subject: Re: [Slony1-general] creating a new trigger for a table on a slave host<br>To: riyav@hotmail.com; slony1-general@lists.slony.info<br><br><div style="color:#000;background-color:#fff;font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt;"><div><span>What version of slony? <br></span></div><div><br><span></span></div><div><span>For 1.2 and earlier </span><span>add the trigger via slonik and </span><span>use store trigger if you want to enable it:</span></div><div><br><span></span></div><div><span>http://slony.info/documentation/1.2/stmtstoretrigger.html</span></div><div><br><span></span></div><div><span>For 2.0 and later use DISABLE/ENABLE
[</span>REPLICA|<span>ALWAYS] TRIGGER in postgresql.</span></div><div><br><blockquote style="margin-left:5px;padding-left:5px;"> <div style="font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Riya V <riyav@hotmail.com><br> <b><span style="font-weight:bold;">To:</span></b> slony1-general@lists.slony.info <br> <b><span style="font-weight:bold;">Sent:</span></b> Tuesday, 5 June 2012, 19:27<br> <b><span style="font-weight:bold;">Subject:</span></b> [Slony1-general] creating a new trigger for a table on a slave host<br> </font> </div> <br><div id="yiv929955892ecxyiv1223328782">
<style><!--
#yiv929955892 .yiv929955892ExternalClass #yiv929955892ecxyiv1223328782 .yiv929955892ecxyiv1223328782hmmessage P
{padding:0px;}
#yiv929955892 .yiv929955892ExternalClass #yiv929955892ecxyiv1223328782 body.yiv929955892ecxyiv1223328782hmmessage
{font-size:10pt;font-family:Tahoma;}
--></style>
<div><div dir="ltr">
<div class="yiv929955892ecxyiv1223328782p1">I need to modify my database schema and create a new trigger function. I know that triggers are suppressed on the slave once Slony starts up. However since slony is now already running on the slave, if I create a new trigger there, it will not be suppressed. What is the best practice for creating a trigger on the slave? Should you take the table out of replication, create trigger , then add the table back in? Is there some other way to do it? </div>
<div class="yiv929955892ecxyiv1223328782p1">Thanks!</div><div class="yiv929955892ecxyiv1223328782p1"><br></div><div class="yiv929955892ecxyiv1223328782p1">RV</div> </div></div>
</div><br>_______________________________________________<br>Slony1-general mailing list<br><a rel="nofollow" ymailto="mailto:Slony1-general@lists.slony.info" target="_blank" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a rel="nofollow" target="_blank" href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a><br><br><br> </div> </div> </blockquote></div> </div></div></div> </div></div>
</div><br><br> </div> </div> </blockquote></div> </div></body></html>