Thread: When are trigger function results committed

Hi All,

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?

Kind Regards,
Keith

"Keith Worthington" <keithw@narrowpathinc.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