PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress

[Peter Olivier <Peter.Olivier@xxxxxxxxxxxx>]

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?