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)
