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

From Leonardo M. Ramé
Subject Re: Update foreign table with trigger
Date
Msg-id 56D0A139.6000007@griensu.com
Whole thread Raw
In response to Re: Update foreign table with trigger  (John R Pierce <pierce@hogranch.com>)
Responses Re: Update foreign table with trigger  (s d <daku.sandor@gmail.com>)
List pgsql-general
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.


--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877


pgsql-general by date:

Previous
From: Leonardo M. Ramé
Date:
Subject: Possible bug in psql 9.4.4
Next
From: Leonardo M. Ramé
Date:
Subject: Re: Possible bug in psql 9.4.4