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

From Tom Lane
Subject Re: When are trigger function results committed
Date
Msg-id 23934.1110381925@sss.pgh.pa.us
Whole thread Raw
In response to When are trigger function results committed  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: When are trigger function results committed
Next
From: John DeSoi
Date:
Subject: Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database