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

Maurice Gittens <mgittens@gits.nl>

From: "Maurice Gittens" <mgittens@gits.nl>
To: "Peter T Mount" <postgresdev@maidast.demon.co.uk>, "David Harvey-George" <DavidH@uk.quza.com>
Cc: <pgsql-hackers@postgreSQL.org>
Date: 1998-03-19T18:50:24Z
Lists: pgsql-hackers

>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