Re: plperl function fails to "fire" Slony trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: plperl function fails to "fire" Slony trigger
Date
Msg-id 5731.1114193330@sss.pgh.pa.us
Whole thread Raw
In response to plperl function fails to "fire" Slony trigger  (Sven Willenberger <sven@dmv.com>)
Responses Re: plperl function fails to "fire" Slony trigger
List pgsql-general
Sven Willenberger <sven@dmv.com> writes:
> We have a replication set up between 2 servers using Slony; both are
> runnind PostgreSQL 8.0.1. The issue is that when updates/inserts are
> made to a replicated table, the replication does not occur; apparently
> this is due to spi_exec somehow not allowing/causing the slony trigger
> function to fire.

Yuck :-(.  The only idea that comes to mind is that 8.0 changed the
timing of trigger firing --- the triggers are probably firing while your
function still has control, whereas in earlier releases they'd only fire
after it returns.  Could this be breaking some assumption Slony makes
about the order of operations?

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: UltraSPARC versus AMD
Next
From: Tom Lane
Date:
Subject: Re: libpq Unicode support?