Sat Apr 17 21:13:53 PDT 2010
- Previous message: [Slony1-general] [slony-general] alter a table that is in two sets
- Next message: [Slony1-general] appending to slony slave log file gets overwritten
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Sat, Apr 17, 2010 at 7:00 PM, Jaime Casanova <jcasanov at systemguards.com.ec> wrote: > 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? Create a third set and move it there and out of the first two sets. Then run ddl. Then merge that back into one set. Create a new set with that table in it and merge it into the other set.
- Previous message: [Slony1-general] [slony-general] alter a table that is in two sets
- Next message: [Slony1-general] appending to slony slave log file gets overwritten
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list