Awesome - Thank you. This did highlight a few more but it brought up
another question:

This query reported for instance my "vessel" table - I have a before insert
and after update trigger (using FB 1.03) both at position 0.



I would imagine this is ok as one trigger or the other/not both will be
invoked.

This query is reporting the following:

VESSEL 4 1 3

VESSEL 6 1 3



Interesting.

Kevin













_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: Tuesday, July 12, 2005 1:07 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Duplicate Trigger Positions

> 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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



[Non-text portions of this message have been removed]