Subject | Re: [firebird-support] Duplicate Trigger Positions |
---|---|
Author | Ann W. Harrison |
Post date | 2005-07-12T21:26:02Z |
Thomas Steinmaurer wrote:
system triggers, but it was resolved before Firebird 1 was released.
When a table is being compiled, the triggers are integrated with a query
like
select rdb$trigger_blr from rdb$triggers
where .....<a variety of checks for system triggers>
order by rdb$trigger_sequence
Nobody cares whether the sequence values are unique, but the order of
duplicates is ill-defined.
Regards
Ann
>There was a problem in InterBase 6 with the relative order of user and
> Might this affect the firing order of system triggers at the same
> position per event/type on system tables negatively?
>
system triggers, but it was resolved before Firebird 1 was released.
When a table is being compiled, the triggers are integrated with a query
like
select rdb$trigger_blr from rdb$triggers
where .....<a variety of checks for system triggers>
order by rdb$trigger_sequence
Nobody cares whether the sequence values are unique, but the order of
duplicates is ill-defined.
Regards
Ann