Subject Re: [firebird-support] Quick storage for one INTEGER variable on Firebird 1.5
Author Milan Babuskov
PenWin wrote:
> Or maybe I am approaching the problem from the wrong side completely?
> Basically, I need to stop a trigger from executing, but only for one
> given transaction; the trigger should fire normally for other transactions.

You could create a special ROLE for this task, grant the role to all
users that need to do it and then connect using that ROLE. In trigger,
simply check CURRENT_ROLE.

http://www.firebirdfaq.org/faq189

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================