Re: plpsql function problem

drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu 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