Re: Update foreign table with trigger

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