Re: Controling Rule's Firing Order - Mailing list pgsql-general

From Tom Lane
Subject Re: Controling Rule's Firing Order
Date
Msg-id 16661.1030076153@sss.pgh.pa.us
Whole thread Raw
In response to Re: Controling Rule's Firing Order  (<cnliou@eurosport.com>)
List pgsql-general
<cnliou@eurosport.com> writes:
> Does foreign key constraints also fire in
> alphabetical order in 7.3?

Foreign key triggers will fire in alphabetical order along with other
triggers.  This means they're firing based on a textual sort of the
OIDs assigned to the triggers, which will often but not always
correspond to creation order.

I'm having a hard time visualizing a situation where it's reasonable
to depend on FK trigger firing order, actually.  Convince me why I
should care about this?

            regards, tom lane

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Controling Rule's Firing Order
Next
From: Jean-Christian Imbeault
Date:
Subject: Foreign keys: how to turn referential integrity constraint off