Hong Yuan hongyuan
Mon May 16 10:54:09 PDT 2005
If you want the new column to be automatically added to the replicated 
table, then you shouldn't add the column manully, but using the EXECUTE 
SCRIPT command of slonik. First you should put your SQL command in a 
file, e.g. structure_change.sql, then put this into your slonik script:

EXECUTE SCRIPT (
    SET ID = your set id,
    FILENAME = 'structure_change.sql',
    EVENT NODE = appropriate node id
)

-- 
HONG Yuan
Homemaster Trading Co., Ltd.
No. 601, Bldg. 41, 288 Shuangyang Rd. (N)
Shanghai 200433, P.R.C.
Tel: +86 21 55056553
Fax: +86 21 55067325
E-mail: hongyuan at homemaster.cn


Matilde L?pez wrote:

> I have a slony replication on one database and I want to know if I 
> need to do anything after I add a column in one table of the set.
> How do I tell the slave node about the new column?
> I can't find information about this in the Slony documentation.
> I'm adding 2 new tables too, but the documentation is ok about this 
> (new set, and merge).
>
> Thank you in advance
> Matilde
>



More information about the Slony1-general mailing list