trigger inheritance

From: fcanedo(at)soneramail(dot)nl
To: pgsql-general(at)postgresql(dot)org
Subject: trigger inheritance
Date: 2001-07-05 13:34:13
Message-ID: Pine.LNX.4.21.0107051519040.1165-100000@mars.privatedomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm new to PostgreSQL and am currently trying to figure out the
object-oriented stuff.

When I make a new table (B) that inherits from another table (A), I would
expect that B inherits the triggers (among other things) from A. It does
not! In the reference manual (CREATE TABLE) it says "Postgres
automatically allows the created table to inherit functions on tables
above it in the inheritance hierarchy."

Since functions don't belong to tables (correct me if I'm wrong) I would
believe triggers are ment here!

So my question is:

Is 'trigger inheritance' available and functional in PostgreSQL 7.1?
If so, how do I turn this on?
If not, is this being worked on (according to the todo, *not*)? Do I need
to take this to the hackers/development list?

For those who are curious:

I solved my problem by manually adding a
trigger for B, that calls the same function that the trigger for A
calls. If necessary I add a new trigger for B (with specific
functionality for B) after adding the "inherited" trigger.
But this is extra work and administration with all it's extra problems.

TIA,

Francisco

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-07-05 13:42:50 Re: Trigger with current user
Previous Message Colin Taylor 2001-07-05 13:29:43 RE: Table Description!!