Joe Martinez wrote:

> A couple questions...
>
> 1) Is there a way to do an insert/update/delete and bypass a trigger
> (prevent it from firing), other than deactivating the trigger?

Ordinarily this is done with a logical test - for example, a particular
user or role is used for inserts and the trigger tests for that
user/role before firing. Alternately, you can store some value in a
dummy table that the trigger tests before firing.

Regards,


Ann

>