inheriting a rule or a trigger? - Mailing list pgsql-sql

From Louis-David Mitterrand
Subject inheriting a rule or a trigger?
Date
Msg-id 20070724143737.GA25948@apartia.fr
Whole thread Raw
Responses Database synchronization  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
List pgsql-sql
Hi,

I'm trying to protect created_by and created_on columns from accidental 
update. Most of my tables inherit from a 'source' table that has those 
columns, so I was thinking of creating a rule or trigger that does 
nothing on update to these columns. But apparently rules and triggers 
don't apply to child tables.

Is there another way to have the same effect, short of a rule/trigger on 
each table?


pgsql-sql by date:

Previous
From: "Peter Childs"
Date:
Subject: Re: is there a 'table' data type in pg?
Next
From: "Jyoti Seth"
Date:
Subject: Database synchronization