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