| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Peter Olivier <Peter(dot)Olivier(at)mediashop(dot)be>, "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:39:07 |
| Message-ID: | 2b21b22a-ff3a-a82f-0fd6-8ee07ce696de@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-07-12 22:42:12 | Re: PostgreSQL FDW + Trigger on Remote DB = WARNING: there is no transaction in progress |
| Previous Message | Tom Lane | 2016-07-12 19:10:42 | Re: pg_restore out of memory |