On Fri, 1 Aug 2008, Yi Zhao wrote:

> ------------
> but, when I do this: cat 1.slon | /usr/local/pgsql/bin/slonik, I got:
> <stdin>:7: PGRES_FATAL_ERROR select "_replication".setAddTable(1, 1,
> 'content.thread_preference', 'thread_treference_pkey', 'nodesc');  -
> ERROR:  Slony-I: cannot add table to currently subscribed set 1
> <stdin>:9: Could not add table content.thread_preference for
> replication!
>
> what's wrong with it?

That's because slony doesn't allow you to directly add tables to a subscribed 
set.  You have to create a new temporary set, add the table(s) and sequence(s) 
to this new set, subscribe the set to the same nodes as the original set, then 
merge the set.  See the "12.1. Adding a table to replication" section of 
the docs here:

http://www.slony.info/documentation/addthings.html

-- 
Jeff Frost, Owner 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954