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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general