Thread

Re: [HACKERS] Re: [QUESTIONS] Inheriting Triggers

Maurice Gittens <mgittens@gits.nl> — 1998-03-19T18:50:24Z

>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