Wed Apr 14 10:07:39 PDT 2010
- Previous message: [Slony1-general] Modifying the schema on the Master and Slave
- Next message: [Slony1-general] Slony-L: alterTableRestore() table with id not found
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Wed, Apr 14, 2010 at 12:49 PM, rsv <riyav at hotmail.com> wrote: > I need to add a new trigger and trigger function on the Master Node. I also > need that trigger on the Slave, should I need to switchover at any point. > However I don't want to dropnode on the slave or stop slony when I do it. Is > there a problem adding a trigger to the Slave while it is being replicated > t Use the slonik command EXECUTE SCRIPT to add your triggers. Whenever you make *any* schema changes that reference any existing table in any way (such as foreign keys, triggers etc) you want to do this. Do not do any schema changes that reference any existing tables on origin or replicas in any other way.
- Previous message: [Slony1-general] Modifying the schema on the Master and Slave
- Next message: [Slony1-general] Slony-L: alterTableRestore() table with id not found
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list