Re: [GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Jan Wieck
On 4/22/2005 2:08 PM, Tom Lane wrote: Sven Willenberger <[EMAIL PROTECTED]> 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 i

[GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Sven Willenberger
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. T

Re: [GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Alvaro Herrera
On Fri, Apr 22, 2005 at 03:09:13PM -0400, Sven Willenberger wrote: > On Fri, 2005-04-22 at 14:43 -0400, Alvaro Herrera wrote: > > On Fri, Apr 22, 2005 at 02:24:57PM -0400, Jan Wieck wrote: > > > On 4/22/2005 2:08 PM, Tom Lane wrote: > > > > > > >Sven Willenberger <[EMAIL PROTECTED]> writes: > > >

Re: [GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Tom Lane
Sven Willenberger <[EMAIL PROTECTED]> 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

Re: [GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Sven Willenberger
On Fri, 2005-04-22 at 14:43 -0400, Alvaro Herrera wrote: > On Fri, Apr 22, 2005 at 02:24:57PM -0400, Jan Wieck wrote: > > On 4/22/2005 2:08 PM, Tom Lane wrote: > > > > >Sven Willenberger <[EMAIL PROTECTED]> writes: > > >>We have a replication set up between 2 servers using Slony; both are > > >>ru

Re: [GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Alvaro Herrera
On Fri, Apr 22, 2005 at 02:24:57PM -0400, Jan Wieck wrote: > On 4/22/2005 2:08 PM, Tom Lane wrote: > > >Sven Willenberger <[EMAIL PROTECTED]> 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 >