<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">>why slony (>= 1.2.17) is not creating (when possible) a TRUNCATE<br>>trigger
to manage that situation? or there is another technique you<br>>are
using?<br><br><br>In section <span style="font-weight: bold;">1.5 Current Limitations</span> of the slony documentation, it specifically states that slony <span style="text-decoration: underline;">cannot</span> generate a truncate trigger. So for replicated tables, it is either best to use a DELETE statement (can take a long time) or manually truncate the specific table in the master and slave. One workaround would be to use a SLONIK EXECUTE SCRIPT to propagate the TRUNCATE to all slaves.<font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);"><br><br>Melvin Davidson </span></font><br><div id="RTEContent"> <font size="3"> </font><font size="3"><span style="font-weight: bold; font-family: courier;"><br></span></font></div><br></td></tr></table><br>