>Then i have a node3 that needs a different set of tables but of them >is on set1, i added that table to the second set and subscribe it to >node3.
Jaime, you should _not_ have a table that is in two different sets. What you should do is A. Create 3 sets. set 1 has the just the common table. set 2 has all but the common table for node 2 set 3 has all but the common table for node 3 B. Subscribe node 2 to set 2 C. Subscribe node 3 to set 3 D. Subscribe both node 2 & node 3 to set 1. Melvin Davidson --- On Sat, 4/17/10, Jaime Casanova <[email protected]> wrote: From: Jaime Casanova <[email protected]> Subject: [Slony1-general] [slony-general] alter a table that is in two sets To: "slony" <[email protected]> Date: Saturday, April 17, 2010, 8:00 PM Hi, Suppose i added a table to a set (set1) in node1 with other tables, and that i subscribe that set to node2. Then i have a node3 that needs a different set of tables but of them is on set1, i added that table to the second set and subscribe it to node3. Now, i need to alter that table (the one that is on the two sets) but in the execute script command i have to indicate the set where the table is, so what can i do? choose one of the two sets randomly? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
