Inheritance and trigger/FK propagation

From: "Davor J(dot)" <DavorJ(at)live(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Inheritance and trigger/FK propagation
Date: 2010-07-15 08:05:52
Message-ID: i1mfj5$1qpt$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems no secret that a child table will not fire a trigger defined on
it's parent table. Various posts comment on this. But nowhere could I find a
reason for this.

Now, I just wonder whether the people who request this are wrong in their
assumption that a trigger should fire on the child table, since those
requests date from 2004 and are still not implemented?

As far as I see propagation has numerous advantages and not-propagation
leads to maintenance problems resulting in data inconsistencies in case of
designs where triggers should propagate. On the other hand, do any design(s)
exist where there should be no propagation?

I think the same could be argued for FK propagation.

I read in the change logs of 8.4: "Force child tables to inherit CHECK
constraints from parents (Alex Hunsaker, Nikhil Sontakke, Tom)." So why not
with triggers and FK's?

Regards,
Davor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2010-07-15 09:02:16 Re: Redundant database objects.
Previous Message Angus Miller 2010-07-15 07:14:26 Paul prefers Postgres