Sowjanya,

You put the ddl into the sql file to run via slonik execute script and the changes are made by slony on the origin and all subscribed nodes.

You shouldn't be doing any ddl on replicated tables outside of slonik.

Glyn

--- On Mon, 10/5/10, sowjanya v <sowjuec at gmail.com> wrote:

From: sowjanya v <sowjuec at gmail.com>
Subject: [Slony1-general] Need Urgent Help
To: slony1-general at lists.slony.info
Date: Monday, 10 May, 2010, 6:29

Hi,

I have two databases db1 and db2. db2 is replica of db1. Now i have added a column in a table in db1. Since schema changes do not propogate by itself to db2, need to execute execute script. But the input for that is a sql file with all  difference in schema. Hence please let me know how replicate the schema changes. If i do the diff of two schemas, it only shows the lines where the difference is present and not the sql command to be executed on db2 to make it same as db1. Please do reply immediately. 


-- 
Sowjanya
  Wipro Technologies
   Bangalore


-----Inline Attachment Follows-----

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100510/70f5857e/attachment.htm