Re: OK to add trigger to sysmaster DB?

Posted in 2000

Topics: Installation, Setup & Upgrades, Triggers, Constraints & Referential Integrity

James Skaife — Thu, 20 Jul 2000 13:18:27 -0600 — source: Informix-list mailing list archive (1991-1998)

Actually, after looking at syssessions, I see it's a view. So I'm really after putting a trigger on sysmaster:sysscblst. Any harm? James Skaife wrote: > > I want to add a delete trigger to the sysmaster:syssessions table. Other > than having to recreate the trigger at upgrade time, is it unwise to > mess with the sysmaster DB? > > Thank You! > James

↪ replying to James Skaife

Sergey Turin — Fri, 21 Jul 2000 12:48:38 +0400 — source: Informix-list mailing list archive (1991-1998)

James, According to manual, triggers against sysmaster database tables are never executed. Best regards, Sergey James Skaife <skaife@ucar.edu> wrote in message news:39775083.BF0EB982@ucar.edu... > Actually, after looking at syssessions, I see it's a view. So I'm really > after putting a trigger on sysmaster:sysscblst. Any harm? > > > > James Skaife wrote: > > > > I want to add a delete trigger to the sysmaster:syssessions table. Other > > than having to recreate the trigger at upgrade time, is it unwise to > > mess with the sysmaster DB? > > > > Thank You! > > James