"William Leite Araújo" <william.bh@gmail.com> writes:
> A trigger start a dblink_exec local connection to insert on a table "A" as
> SuperUser. Table "A" fires insert trigger that, by LOG messages, ends, but
> the function never return to initial trigger.
Perhaps the other transaction is blocked on some lock held by your
original transaction?
dblink connections to your own database are very seldom a good idea;
there is always a better, more efficient, less deadlock-prone way
to do it. In this case I'd venture that you want to use a SECURITY
DEFINER function, and not dblink at all.
regards, tom lane