Re: Controling Rule's Firing Order

Thank you! Alvaro and Stephan,

> The name of a foreign key trigger is a constant
> beginning followed by an oid.

Now I think I have found that FK trigger names look
like this:

RI_ConstraintTrigger_<OID>

> but you should be able to make triggers run
> before/after the foreign key trigger by picking
> names before/after the constant part of the
> fk trigger name.

Yes, this is the way for me to go. The last missing
better-have feature is the firing order among FK
triggers for master and detail tables:

- When the primary key of master record is to be
updated, the primary key of this master record is
updated before those of its child records.

- When the master record is to be deleted, its detail
records are first deleted.

Best Regards,

CN

--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com