Suppressing Trigger Action

Posted in 1999

Topics: Triggers, Constraints & Referential Integrity

Nayan Jain — Fri, 28 May 1999 12:50:50 +0530 (IST) — source: Informix-list mailing list archive (1991-1998)

Hi all, I have a trigger on an insert in table. Is there any way that i can suppress the trigger action on INSERT. In another word, i want to insert into the table but do not want the trigger to be fired. Any way to do that ? TIA, Nayan !

↪ replying to Nayan Jain

san — Fri, 28 May 1999 13:08:21 +0400 — source: Informix-list mailing list archive (1991-1998)

Simply remove trigger Nayan Jain <nayan.jain@tatainfotech.com> wrote in message news:7ili3i$22$1@news.xmission.com... > > Hi all, > > I have a trigger on an insert in table. Is there any way that i can > suppress the trigger action on INSERT. > > In another word, i want to insert into the table but do not want the > trigger to be fired. > > Any way to do that ? > > TIA, > Nayan ! > >

↪ replying to Nayan Jain

Tony Flaherty — Fri, 28 May 1999 15:12:21 +0100 — source: Informix-list mailing list archive (1991-1998)

There is a disable triggers for table command, or something similar, RTFM I had limited success with this though, IIRC problems with locking the table during execution of the command. -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf . Nayan Jain wrote in message <7ili3i$22$1@news.xmission.com>... > >Hi all, > >I have a trigger on an insert in table. Is there any way that i can >suppress the trigger action on INSERT. > >In another word, i want to insert into the table but do not want the >trigger to be fired. > >Any way to do that ? > >TIA, >Nayan ! > >

↪ replying to Nayan Jain

Art S. Kagel — Fri, 28 May 1999 13:02:36 -0400 — source: Informix-list mailing list archive (1991-1998)

Nayan Jain wrote: > > Hi all, > > I have a trigger on an insert in table. Is there any way that i can > suppress the trigger action on INSERT. > > In another word, i want to insert into the table but do not want the > trigger to be fired. > > Any way to do that ? SET TRIGGERS FOR mytable DISABLED; INSERT INTO mytable ....... SET TRIGGERS FOR mytable ENABLED; Art S. Kagel

↪ replying to Nayan Jain

Khem Chander — Fri, 28 May 1999 20:04:06 -0700 — source: Informix-list mailing list archive (1991-1998)

HI Buddy, You can use the statement set triggers on tablename to disabled. Then until you enable the trigger back the trigger will not fire. But you will need to be the DBA or be the owner of the table or have alter privilege on the table and resource privelege on the database. Thanks, khem Chander. kchande@yahoo.com Nayan Jain wrote: > Hi all, > > I have a trigger on an insert in table. Is there any way that i can > suppress the trigger action on INSERT. > > In another word, i want to insert into the table but do not want the > trigger to be fired. > > Any way to do that ? > > TIA, > Nayan !