>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 <jcasanov at systemguards.com.ec> wrote:

From: Jaime Casanova <jcasanov at systemguards.com.ec>
Subject: [Slony1-general] [slony-general] alter a table that is in two sets
To: "slony" <slony1-general at lists.slony.info>
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
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100417/520a1fd4/attachment.htm