When are trigger function results committed - Mailing list pgsql-novice

From Keith Worthington
Subject When are trigger function results committed
Date
Msg-id 20050309150847.M6609@narrowpathinc.com
Whole thread Raw
Responses Re: When are trigger function results committed
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Foreign key error, please help.
Next
From: Tom Lane
Date:
Subject: Re: When are trigger function results committed