Re: Update foreign table with trigger

From: Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com>
To: s d <daku(dot)sandor(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Update foreign table with trigger
Date: 2016-02-26 20:02:29
Message-ID: 56D0AF55.1090609@griensu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El 26/02/16 a las 16:49, s d escribió:
> On 26 February 2016 at 20:42, Leonardo M. Ramé <l(dot)rame(at)griensu(dot)com
> <mailto:l(dot)rame(at)griensu(dot)com>> wrote:
>
>
>
>
> Then try to do the update on the remote db directly.
>
> In the meantime could you provide the table and trigger definitions?
>
>
> I don't understand why the trigger is run in the caller database
> instead of the called (foreign) one.
>
>
> It isn't. You get this error message because the reason why the local
> command fails is in the remote trigger somewhere.
>

But, when I update TABLE_A from the remote server everything works ok.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message s d 2016-02-26 20:11:44 Re: Update foreign table with trigger
Previous Message David G. Johnston 2016-02-26 19:51:21 Re: Possible bug in psql 9.4.4