When are trigger function results committed

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: When are trigger function results committed
Date: 2005-03-09 15:20:30
Message-ID: 20050309150847.M6609@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-03-09 15:21:00 Re: Foreign key error, please help.
Previous Message Kumar S 2005-03-09 14:46:45 Re: Foreign key error, please help.