Re: When are trigger function results committed

"Keith Worthington" <keithw(at)narrowpathinc(dot)com> writes:
> I have a table with three trigger functions on it. After insert the first
> (defined alphabetically) trigger fires and performs its task. Then the second
> and finally the third triggers fire. It does not appear that the second
> trigger can see the results of the third trigger and the third cannot see the
> results of the forth trigger. Is this the expected behavior? If so can
> anyone suggest how I can make the functions see the previous results?

Define "see" --- what did you try to do *exactly*? And which PG version
is this?

regards, tom lane