Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread Leonardo M . Ramé
El 26/02/16 a las 17:11, s d escribió: On 26 February 2016 at 21:02, Leonardo M. Ramé mailto:l.r...@griensu.com>> wrote: El 26/02/16 a las 16:49, s d escribió: On 26 February 2016 at 20:42, Leonardo M. Ramé mailto:l.r...@griensu.com>

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 21:02, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:49, s d escribió: > >> On 26 February 2016 at 20:42, Leonardo M. Ramé > > wrote: >> >> >> >> >> Then try to do the update on the remote db directly. >> >> In the meantime co

Re: [GENERAL] Update foreign table with trigger

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

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 20:42, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:33, s d escribió: > >> On 26 February 2016 at 20:19, Leonardo M. Ramé > > wrote: >> >> >> >> El 26/02/16 a las 16:18, s d escribió: >> >> >> On 26 February 2016 at 20:02, Leonar

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread Leonardo M . Ramé
El 26/02/16 a las 16:33, s d escribió: On 26 February 2016 at 20:19, Leonardo M. Ramé mailto:l.r...@griensu.com>> wrote: El 26/02/16 a las 16:18, s d escribió: On 26 February 2016 at 20:02, Leonardo M. Ramé mailto:l.r...@griensu.com>

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 20:19, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:18, s d escribió: > >> >> On 26 February 2016 at 20:02, Leonardo M. Ramé > > wrote: >> >> >> El 26/02/16 a las 15:55, John R Pierce escribió: >> >> On 2/26/2016 10:29 AM, Leonar

Re: [GENERAL] Update foreign table with trigger

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

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 20:02, Leonardo M. Ramé 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

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread Leonardo M . Ramé
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 fo

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread John R Pierce
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 tr

[GENERAL] Update foreign table with trigger

2016-02-26 Thread Leonardo M . Ramé
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. At this point I have two foreign tables, TABLE_A and TABL