Re: trigger firing order - Mailing list pgsql-sql

From chester c young
Subject Re: trigger firing order
Date
Msg-id 283819.32478.qm@web54303.mail.re2.yahoo.com
Whole thread Raw
In response to Re: trigger firing order  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-sql
> > does the post trigger on A wait until post trigger on B is
> executed? -> > this seems intuitive to me.
> 
> How can it wait until the trigger on B is executed if the trigger on
> B doesn't
> actually get triggered until someone updates B and it's the trigger
> on A
> doing the update?

trigger A executes until it updates table B, at which point it does it
pause execution until the post update trigger on table B completes, and
then trigger A resumes at the next statement.


      
____________________________________________________________________________________
Pinpoint customers who are looking for what you sell. 
http://searchmarketing.yahoo.com/


pgsql-sql by date:

Previous
From: Gregory Stark
Date:
Subject: Re: trigger firing order
Next
From: Rodrigo De León
Date:
Subject: Re: inner join problem with temporary tables