Subject | Re: [firebird-support] Duplicate Trigger Positions |
---|---|
Author | Thomas Steinmaurer |
Post date | 2005-07-12T20:07Z |
> Cool - as long as both still fired. (I have fixed them :)Cool. Care to get all duplicate trigger positions with the following
system table query: ;-))
select
rdb$relation_name
, rdb$trigger_type
, rdb$trigger_sequence
, count(*)
from
rdb$triggers
where
rdb$system_flag is null or rdb$system_flag = 0
group by rdb$relation_name, rdb$trigger_type, rdb$trigger_sequence
having count(*) > 1
order by rdb$relation_name
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com