Update foreign table with trigger - Mailing list pgsql-general

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 TABLE_B.

Now, when I try to do an update on TABLE_A, I get relation "TABLE_B"
does not exist.

Here's what I get:

update TABLE_A set updated=true where id=1234;

ERROR:  relation "TABLE_B" does not exist
CONTEXT:  Remote SQL command: UPDATE public.TABLE_A SET updated = $2
WHERE ctid = $1
PL/pgSQL function public.TABLE_A_update() line 4 at SQL statement

Any hint?.


Regards
--
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