Triggers inherited?

From: Bertram Scharpf <lists(at)bertram-scharpf(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Triggers inherited?
Date: 2007-02-22 19:04:18
Message-ID: 20070222190418.GE6998@bart.bertram-scharpf.homelinux.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

it is very inconvenient for me that triggers aren't inherited:

create table watch (
mod timestamp with time zone default '-infinity' not null
);

create function update_mod() returns trigger ...

create trigger update_mod before insert or update on watch
for each row execute procedure update_mod();

create table some ( ... ) inherits (watch);
create table other ( ... ) inherits (watch);

Is this behaviour to be implemented at any point of time in
the future? Could it be advisible to write the patch? Or is
it just too easy to emulate it?

Reimplemeting a trigger for each descending table definitely
dosn't satisfy me.

Thanks in advance,

Bertram

--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-02-22 19:15:00 Re: php professional
Previous Message Tomas Simonaitis 2007-02-22 18:38:52 Re: Moving WAL files