Skip site navigation (1) Skip section navigation (2)

Re: [QUESTIONS] Inheriting Triggers

From: Peter T Mount <postgresdev(at)maidast(dot)demon(dot)co(dot)uk>
To: David Harvey-George <DavidH(at)uk(dot)quza(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [QUESTIONS] Inheriting Triggers
Date: 1998-03-18 19:06:15
Message-ID: Pine.LNX.3.95.980318190128.30928B-100000@maidast (view raw, whole thread or download thread mbox)
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 did ask about this last weekend (while looking at some features for
JDBC). This looks like a similar problem.

Peter T Mount  petermount(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage:
Work Homepage: Work EMail: peter(at)maidstone(dot)gov(dot)uk

pgsql-hackers by date

Next:From: Kent S. GordonDate: 1998-03-18 19:28:44
Subject: Re: [HACKERS] standards question
Previous:From: The Hermit HackerDate: 1998-03-18 16:44:05
Subject: Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group