Which version of slony? In 1.2.X use sloniks STORE TRIGGER command, in 2.0 use postgres ENABLE ALWAYS TRIGGER 


--- On Fri, 20/2/09, Steve Holdoway <steve at greengecko.co.nz> wrote:

> From: Steve Holdoway <steve at greengecko.co.nz>
> Subject: [Slony1-general] Firing a trigger on a slony replicated table...
> To: slony1-general at lists.slony.info
> Date: Friday, 20 February, 2009, 11:26 PM
> Hey all, I'm trying to get a trigger to fire when an
> event happens on a slave table, replicated through slony
> 2.0.0. I know that the triggers work when I bulk load from
> file ( insert or copy syntax ), but when the table's
> under the control of slony, the addition of a row to the
> table doesn't trigger the event - which is a reformat of
> incoming data, and publishing to a new table.
> 
> I've tried adding the trigger before insert or update
> or delete, and after same, but to no avail.
> 
> Has anyone any ideas??
> 
> Cheers,
> 
> Steve
> -- 
> Steve Holdoway <steve at greengecko.co.nz>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general