Received: from job.gits.nl (job.gits.nl [194.178.243.251]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA00276 for ; Thu, 19 Mar 1998 13:52:06 -0500 (EST) Received: from caleb..gits.nl (caleb.gits.nl [194.178.243.252]) by job.gits.nl (8.8.7/8.8.7) with SMTP id TAA24049; Thu, 19 Mar 1998 19:58:33 -0500 Message-ID: <006901bd5367$e098f760$fcf3b2c2@caleb..gits.nl> From: "Maurice Gittens" To: "Peter T Mount" , "David Harvey-George" Cc: Subject: Re: [HACKERS] Re: [QUESTIONS] Inheriting Triggers Date: Thu, 19 Mar 1998 19:50:24 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 >On Wed, 18 Mar 1998, David Harvey-George wrote: > >> I found that triggers don't get inherited... or rather the triggers >> for the superclass don't get checked when inserting or updating rows >> when enforcing referential intregrity. This is a bit of a pain as it >> means I have to duplicate a lot of triggers. Any idea if this can be >> fixed? Presumably this would mean 'fixing' to the TRIGGER handling >> code to look up the inheritance stack calling the appropriate >> triggers? >> >> Maybe like inheriting PRIMARY KEY attributes this is more of a >> feature? > I'm glad that I'm not the only one who is of the opinion that inheritance is needed for triggers and the like. Regards, Maurice