Thread: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
From
Peter Olivier
Date:
Hi,
I have the following setup:
Database Local has a table L1
Database Remote has a table R1 and a table R2.
Table Remote.R1 has a trigger. This trigger updates Remote.R2
I create a foreign table F1 on Database local which points to Remote.R1
When updating F1 the trigger on Remote.R1 fires but gives the following warning:
WARNING: there is no transaction in progress
When the trigger does not update another table everything works fine.
Any suggestions?
Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
From
Adrian Klaver
Date:
On 07/12/2016 02:39 AM, Peter Olivier wrote: > Hi, > > > > I have the following setup: > > > > Database Local has a table L1 > > Database Remote has a table R1 and a table R2. > > Table Remote.R1 has a trigger. This trigger updates Remote.R2 > > > > I create a foreign table F1 on Database local which points to Remote.R1 > > > > When updating F1 the trigger on Remote.R1 fires but gives the following > warning: > > WARNING: there is no transaction in progress > > > > When the trigger does not update another table everything works fine. > > > > Any suggestions? Yes more information: What version of Postgres? What is the database on the remote end, I am assuming Postgres, so what version? What FDW? > > > > > -- Adrian Klaver adrian.klaver@aklaver.com
Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
From
Tom Lane
Date:
Peter Olivier <Peter.Olivier@mediashop.be> writes:
> I create a foreign table F1 on Database local which points to Remote.R1
> When updating F1 the trigger on Remote.R1 fires but gives the following warning:
> WARNING: there is no transaction in progress
Seems odd, but I think you'll have to give a complete example for
anyone to diagnose it. Also, what PG versions are in use exactly,
both local and remote?
regards, tom lane