Sorry it appears I cannot read. You said 2.0


--- On Sat, 21/2/09, Glyn Astill <glynastill at yahoo.co.uk> wrote:

> From: Glyn Astill <glynastill at yahoo.co.uk>
> Subject: Re: [Slony1-general] Firing a trigger on a slony replicated table...
> To: slony1-general at lists.slony.info, "Steve Holdoway" <steve at greengecko.co.nz>
> Date: Saturday, 21 February, 2009, 12:38 AM
> 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
> 
> 
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general