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

[Peter Olivier]

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?