Mon Nov 23 08:40:09 PST 2009
- Previous message: [Slony1-general] Getting benign AFTER triggers to fire on slaves only
- Next message: [Slony1-general] Getting benign AFTER triggers to fire on slaves only
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Perhaps this is what you want? STORE TRIGGER=A0--=A0 Indicate that a trigger should not be disabled by Slony-I on a subscriber node = http://slony.info/documentation/stmtstoretrigger.html Melvin Davidson = --- On Mon, 11/23/09, Peter Geoghegan <peter.geoghegan86 at gmail.com> wrote: From: Peter Geoghegan <peter.geoghegan86 at gmail.com> Subject: [Slony1-general] Getting benign AFTER triggers to fire on slaves o= nly To: slony1-general at lists.slony.info Date: Monday, November 23, 2009, 10:00 AM Hello, I have a novel requirement; I'd like to fire AFTER triggers on replicated tables, that don't modify the database, on slaves only. These triggers just send notifications to client apps that connect to the slave, which cause them to refresh their view to the table, so the user doesn't have to refresh it themselves - that is all. I've noticed that Slony-I disables my AFTER triggers on the slaves (they actually don't even exist on the master).=A0 While I understand the rationale in having Slony do this, this is clearly something I can safely override. Does what I want seem reasonable? I see that I can ALTER TABLE my_table ENABLE REPLICA TRIGGER my_trig and get the desired behaviour. Should I just make a point of doing this after replication has been setup on all slaves? I'm using Slony 2.0.2, with Postgres 8.3.5 on the slave and 8.4.1 on the ma= ster. Regards, Peter Geoghegan _______________________________________________ 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/20091123/= d5088f09/attachment.htm
- Previous message: [Slony1-general] Getting benign AFTER triggers to fire on slaves only
- Next message: [Slony1-general] Getting benign AFTER triggers to fire on slaves only
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list