Christopher Browne cbbrowne at ca.afilias.info
Mon Jul 6 10:59:35 PDT 2009
Stuart Bishop <stuart at stuartbishop.net> writes:
> (I wish Slony-I had ADD TABLE so we didn't all have to implement this
> logic in our maintenance tools...)

That would certainly be nice to have; the trouble is that there are
substantial complications in the subscription logic surrounding the
issue of copying the data consistently.

I'll note that there is a function, add_empty_table_to_replication(),
added a while back, which you could run as part of EXECUTE SCRIPT,
just after adding the empty table to the schema.

Not quite as good as an "ADD TABLE ... to existing set ...", but not
VASTLY distant :-).

http://www.slony.info/documentation/partitioning.html
-- 
let name="cbbrowne" and tld="ca.afilias.info" in name ^ "@" ^ tld;;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"


More information about the Slony1-general mailing list