<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">>Then i have a node3 that needs a different set of tables but of them<br>>is
on set1, i added that table to the second set and subscribe it to<br>>node3.<br><br>Jaime,<br><br>you should _not_ have a table that is in two different sets. What you should do is<br>A. Create 3 sets.<br> set 1 has the just the common table.<br> set 2 has all but the common table for node 2<br> set 3 has all but the common table for node 3<br>B. Subscribe node 2 to set 2<br>C. Subscribe node 3 to set 3<br>D. Subscribe both node 2 & node 3 to set 1.<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><br><font style="font-weight: bold;" size="3"><span style="color: rgb(128, 0, 255);"></span></font><font size="3"><span style="font-weight: bold; font-family: courier;"></span></font><br></div>--- On <b>Sat, 4/17/10, Jaime Casanova
<i><jcasanov@systemguards.com.ec></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Jaime Casanova <jcasanov@systemguards.com.ec><br>Subject: [Slony1-general] [slony-general] alter a table that is in two sets<br>To: "slony" <slony1-general@lists.slony.info><br>Date: Saturday, April 17, 2010, 8:00 PM<br><br><div class="plainMail">Hi,<br><br>Suppose i added a table to a set (set1) in node1 with other tables,<br>and that i subscribe that set to node2.<br>Then i have a node3 that needs a different set of tables but of them<br>is on set1, i added that table to the second set and subscribe it to<br>node3.<br><br>Now, i need to alter that table (the one that is on the two sets) but<br>in the execute script command i have to indicate the set where the<br>table is, so what can i do? choose one of the two sets randomly?<br><br>-- <br>Atentamente,<br>Jaime
Casanova<br>Soporte y capacitación de PostgreSQL<br>Asesoría y desarrollo de sistemas<br>Guayaquil - Ecuador<br>Cel. +59387171157<br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info" href="/mc/compose?to=Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br></div></blockquote></td></tr></table><br>