Re: Triggers or not triggers ?

Posted in 1999

Diego Morales — Thu, 28 Oct 1999 13:31:55 +0200 — source: Informix-list mailing list archive (1991-1998)

SYSTRIGGERS The systriggers system catalog table contains miscellaneous information about the SQL triggers in the database. This information includes the trigger event and the correlated reference specification for the trigger. The systriggers system catalog table has the columns shown in the following table. Column Name /Type /Explanation trigid /SERIAL /Trigger identifier trigname /NCHAR(18) /Trigger name owner /NCHAR(8) /Owner of trigger tabid /INT /ID of triggering table event /NCHAR /Triggering event: I (insert), U (update) or D (delete) old /NCHAR(18) /Name of value before update new /NCHAR(18) /Name of value after update mode /NCHAR /Reserved for future use A composite index for the trigname and owner columns allows only unique values. The trigid column is indexed and must contain unique values. An index for the tabid column allows duplicate values. I'm not sure but I think it's impossible to "disable" a trigger. If you want to be sure that this trigger must not work, delete it! I think it's the best way.