Re: Multiple Triggers of Same Type on Same Table?

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Tue, 30 May 2006 16:14:10 +0400
Message-ID: <e5hcuj$266i$1@hypnos.nordnet.ru>

"Advo" <x_at_x.com> wrote in message
news:UsTeg.5329$C9.3954_at_newsfe4-win.ntli.net...
>I have just been looking into triggers, and how that having multiple
>triggers of the same type, on the same table is allowed (but isnt ideal at
>all, because of the fact the order they fire in is random..)
>
> so, why is it allowed in like Standard SQL?
>
> I can't find an actual reason, other than the fact that it is because of
> market pressure from 3rd party developers.. but any other actual reasons
> for this?
>

One possible reason could be that such triggers can be owned by different database users.

regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Tue May 30 2006 - 07:14:10 CDT