Re: Update foreign table with trigger

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

On 26 February 2016 at 20:42, Leonardo M. Ramé <l(dot)rame(at)griensu(dot)com> wrote:

>
>
> El 26/02/16 a las 16:33, s d escribió:
>
>> On 26 February 2016 at 20:19, Leonardo M. Ramé <l(dot)rame(at)griensu(dot)com
>> <mailto:l(dot)rame(at)griensu(dot)com>> wrote:
>>
>>
>>
>> El 26/02/16 a las 16:18, s d escribió:
>>
>>
>> On 26 February 2016 at 20:02, Leonardo M. Ramé
>> <l(dot)rame(at)griensu(dot)com <mailto:l(dot)rame(at)griensu(dot)com>
>> <mailto:l(dot)rame(at)griensu(dot)com <mailto:l(dot)rame(at)griensu(dot)com>>> wrote:
>>
>>
>> El 26/02/16 a las 15:55, John R Pierce escribió:
>>
>> On 2/26/2016 10:29 AM, Leonardo M. Ramé wrote:
>>
>> Hi, I created a Postgres_FDW table (TABLE_A) and
>> need to do
>> an update on that table.
>>
>> As TABLE_A has a trigger, and the trigger does an
>> insert on
>> another table (TABLE_B), I had to create another
>> foreign
>> table called TABLE_B, that's ok.
>>
>>
>>
>> that trigger is defined on the server that actually has
>> table_a,
>> right? or did you define a trigger on the FDW table ?
>>
>> Hi John, yes, the trigger is only defined on the foreign
>> server.
>>
>>
>> Let's check we get this right!
>> You have two "real" table in the remote server with a trigger
>> doing it's
>> job on them and on the local server you have and FDW on each
>> remote
>> table. Right?
>>
>>
>> Yes, that's right.
>>
>>
>> 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.

Ezt az e-mailt egy Avast védelemmel rendelkező, vírusmentes számítógépről
küldték.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-02-26 19:51:21 Re: Possible bug in psql 9.4.4
Previous Message Leonardo M. Ramé 2016-02-26 19:42:39 Re: Update foreign table with trigger