[EMAIL PROTECTED] writes:
> function
> .
> insert into table1 ... --> trigger function (runs after insert)
> .
> insert into table2 ...
> .
> select from table2 ... not found
> .
> This info looks to be unavailable inside the function. Can it be made
> availabel or must this whole thing reorgenized?
If it's an AFTER trigger, the trigger is currently not fired until the
end of the entire command (ie, whatever interactive command called your
function). So the SELECT isn't seeing the result because it hasn't
happened yet.
This will change in PG 8.0.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
