trigger firing order

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: trigger firing order
Date: 2007-06-16 02:08:13
Message-ID: 466219.19714.qm@web54302.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

tables A and B: a post row trigger on A cause updates on B which has
its own post row trigger.

does the post trigger on A wait until post trigger on B is executed? -
this seems intuitive to me.

does the post trigger on B wait until the trigger on A has completed?

or is post trigger A launched as its own process (in which case who
completes first is indeterminate).

or am I missing this entirely?

pre-row thanks for your insight!

____________________________________________________________________________________
Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gregory Stark 2007-06-16 03:03:59 Re: trigger firing order
Previous Message operationsengineer1 2007-06-15 16:42:56 Re: Organization of tables