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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Triggers inherited?


  • From: Bertram Scharpf <lists(at)bertram-scharpf(dot)de>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Triggers inherited?
  • Date: Thu, 22 Feb 2007 20:04:18 +0100
  • Message-id: <20070222190418(dot)GE6998(at)bart(dot)bertram-scharpf(dot)homelinux(dot)com>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group