OK to add trigger to sysmaster DB?

Posted in 2000

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

James Skaife — Thu, 20 Jul 2000 11:59:32 -0600 — source: Informix-list mailing list archive (1991-1998)

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

Art S. Kagel — Fri, 21 Jul 2000 11:05:46 -0400 — source: Informix-list mailing list archive (1991-1998)

Remember that the SMI tables (ie sysmaster) are NOT real tables but a window into shared memory and disk structures. These underlying structures are NEVER updated through the SMI interface but by direct manipulation of the underlying structure so triggers never fire! Art S. Kagel 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