"Johnny Edge" <jedge at visafirst.com> writes:
> So far this was suggested.
>
> 1. Create a "dummy" set (id=999)
> 2. Add the new table to set 999
> 3. Subscribe to the new set 999
> 4. Merge set 999 with set 1
>
>  
>
> Can you provide an example? 

There are examples of these sorts of things in the manual pages.

http://slony.info/documentation/stmtcreateset.html
http://slony.info/documentation/stmtsetaddtable.html
http://slony.info/documentation/stmtsubscribeset.html
http://slony.info/documentation/stmtmergeset.html

> Can the whole procedure be 'simplified' to altering the existing
> sequence with SQL queries, i.e. add new record for the new table?

Conceivably, but that's likely to be more fragile than using the
Slonik commands that are designed to do the job.

> Do I have to create a new cluster that is to be merged with the
> existing one?

No, if you created another cluster, it would be impossible to merge
that with the existing cluster.

http://slony.info/documentation/cluster.html
-- 
output = ("cbbrowne" "@" "ca.afilias.info")
<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"