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

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