Re: Order of execution of Constraints, Triggers and Rules

On Fri, 6 Dec 2002, Jean-Luc Lachance wrote:

> Jean-Luc Lachance wrote:
> >
> > Hi all,
> >
> > I know triggers are executed in alphabetical order, but which of
> > constraints, triggers and rules get executed first and which one is
> > last?

I think it's:

Rules are processed (since they're rewrites).
Before triggers (in order)
Check constraints/not null/unique/primary key
After triggers (before the foreign key triggers)
Foreign keys
After triggers (after the foreign key triggers)