Обсуждение: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress

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?

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

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