Mon May 16 10:54:09 PDT 2005
- Previous message: [Slony1-general] Adding a column
- Next message: [Slony1-general] Adding a column
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 >
- Previous message: [Slony1-general] Adding a column
- Next message: [Slony1-general] Adding a column
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list