Subject Re: [firebird-support] Duplicate Trigger Positions
Author Thomas Steinmaurer
> 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