Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
Date
Msg-id 12851.1468363332@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress  (Peter Olivier <Peter.Olivier@mediashop.be>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
Next
From: "dandl"
Date:
Subject: Re: Question about antijoin