The following bug has been logged online:
Bug reference: 2372
Logged by: William Leite Araújo
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.7
Operating system: i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5
(Debian 1:3.3.5-13)
Description: dblink_exec doesn't return. NEVER!
Details:
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.
UPDATE TRIGGER T call dblink_exec to INSERT
REMOTE INSERT fire TRIGGER that ends, but bdlink_exec doesn't return on
trigger.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
