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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
