<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:tahoma,new york,times,serif;font-size:12pt">>This is not required for adding new tables that stand alone (ie have not FKs) or for function <br>>definitions.<br><br>Not necessarily true. Simply put, if you want your slaves to stay in sync with the master, I highly recommend you use EXECUTE SCRIPT to propagate changes across all nodes. Even if the new object will not be immediately replicated, it's always best to insure schemas are identical on all nodes.<br>Note: There is no requirement to do this, just good practice. If you forget to manually create a table on all nodes and then add it to replication later, it will definitely bite you where i hurts. And if you have to fail over and the object isn't there, can you say for sure things will be fine?<br><br><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial;
color: rgb(0, 0, 255);">Melvin Davidson </span></font><br> <font size="3"> </font></div><div style="font-family: tahoma,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Vick Khera <vivek@khera.org><br><b><span style="font-weight: bold;">To:</span></b> slony <slony1-general@lists.slony.info><br><b><span style="font-weight: bold;">Sent:</span></b> Monday, October 5, 2009 1:10:26 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [Slony1-general] when creating new table with FK reference to existing replicated table, do I need to run via EXECUTE SCRIPT?<br></font><br>
On Mon, Oct 5, 2009 at 11:07 AM, Melvin Davidson <<a ymailto="mailto:melvin6925@yahoo.com" href="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>> wrote:<br>>>Does that create table command need to be run via EXECUTE SCRIPT in slony1?<br>><br>> Yes. Whenever you create or modify objects, you should always use EXECUTE<br>> SCRIPT.<br>> Doing so insures that the changes are propagated across all nodes.<br><br>This is not required for adding new tables that stand alone (ie have<br>not FKs) or for function definitions.<br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><span><a target="_blank" href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a></span><br></div></div></div><br>
</body></html>