I see in the docs for SLONIK STORE TRIGGER that a "nifty trick is that you
can run STORE TRIGGER *before the trigger is installed;* that will not cause
any errors." That suggests to me that it doesn't matter that the trigger
doesn't actually exist on the master. Does it matter?

Regards,
Peter Geoghegan

2009/11/23 Melvin Davidson <melvin6925 at yahoo.com>

> Perhaps this is what you want?
>
> STORE TRIGGER --  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>*wrot=
e:
>
>
> From: Peter Geoghegan <peter.geoghegan86 at gmail.com>
> Subject: [Slony1-general] Getting benign AFTER triggers to fire on slaves
> only
> 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).  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
> master.
>
> Regards,
> Peter Geoghegan
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info<http://mc/compose?to=3DSlony1-general@lis=
ts.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/=
7eccd51a/attachment.htm