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

2016-07-12 Thread Tom Lane
Peter Olivier 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 a

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

2016-07-12 Thread Adrian Klaver
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.R

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

2016-07-12 Thread 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