Re: Update foreign table with trigger - Mailing list pgsql-general

From Leonardo M. Ramé
Subject Re: Update foreign table with trigger
Date
Msg-id 56D0AF55.1090609@griensu.com
Whole thread Raw
In response to Re: Update foreign table with trigger  (s d <daku.sandor@gmail.com>)
Responses Re: Update foreign table with trigger  (s d <daku.sandor@gmail.com>)
List pgsql-general

El 26/02/16 a las 16:49, s d escribió:
> On 26 February 2016 at 20:42, Leonardo M. Ramé <l.rame@griensu.com
> <mailto:l.rame@griensu.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.


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Possible bug in psql 9.4.4
Next
From: s d
Date:
Subject: Re: Update foreign table with trigger