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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Olivier <Peter(dot)Olivier(at)mediashop(dot)be>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress
Date: 2016-07-12 22:42:12
Message-ID: 12851.1468363332@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Olivier <Peter(dot)Olivier(at)mediashop(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Dawborn 2016-07-12 23:05:53 Re: Upsert with a partial unique index constraint violation
Previous Message Adrian Klaver 2016-07-12 22:39:07 Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress