Re: trigger firing order

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "chester c young" <chestercyoung(at)yahoo(dot)com>
Cc: "sql pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: trigger firing order
Date: 2007-06-16 03:03:59
Message-ID: 87abv0ppls.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"chester c young" <chestercyoung(at)yahoo(dot)com> writes:

> 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.

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?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chester c young 2007-06-16 05:43:04 Re: trigger firing order
Previous Message chester c young 2007-06-16 02:08:13 trigger firing order