RE: Trigger deletion

Srini, Have you tried to "undelete" it? Pick another similar trigger, and "unload to trigg.txt select <another-trig> from systtriggers;". Edit trigg.txt to change the name <another-trig> to <triggername>. Then "load from trigg.txt insert into systriggers;" Then, do the onchecks, and thentry to drop it properly. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Srinivas Sreekumar Sent: Friday, June 03, 2005 12:42 AM To: informix-list@iiug.org Subject: Trigger deletion 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 Scott MacKenzie - Dine' College ISD Phone/Voice Mail: 928-724-3376 Email: scottm at dinecollege.edu sending to informix-list