Trigger deletion
Posted in 2005
Srinivas Sreekumar — — source: Usenet: comp.databases.informix
Hi All, We had mistakenly deleted a trigger from the systriggers table of our database (Informix) using "delete from systriggers where trigname = <triggername>"...instead of using the "drop trigger <triggername>" command. As a result of which our sysobjstate table got corrupted. Now, we are not able to load the trigger nor could we create forms for the table(for which the trigger was deleted). Any source of information would be helpful. " Thanks - Srini sending to informix-list