Inheritance and rules/triggers

From: Christopher Masto <chris+pg-general(at)netmonger(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Inheritance and rules/triggers
Date: 2001-04-17 21:27:32
Message-ID: 20010417172732.A19116@netmonger.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

For some reason, I assumed that rules and triggers on a base table
would run when operations are performed on inherited tables. After I
spent the day setting up some tables and functions based on that
assumption, I discovered that it seems to be incorrect.

I'm posting this in the hope that I'm missing something. I hope. Please.

My system has a lot of tables which are linked to some information which
must be updated when any of them are updated. If we miss one or add a new
table in the future and forget to set the trigger, it would be a major
problem. I thought using a trigger on the base table would be a clever
solution. :-/
--
Christopher Masto Senior Network Monkey NetMonger Communications
chris(at)netmonger(dot)net info(at)netmonger(dot)net http://www.netmonger.net

Free yourself, free your machine, free the daemon -- http://www.freebsd.org/

Browse pgsql-general by date

  From Date Subject
Next Message Nils Zonneveld 2001-04-17 21:56:56 Re: No backspace key in the psql command-line tool?
Previous Message Tom Lane 2001-04-17 21:23:44 Re: scan.c:900: warning: ... postgresql-7.1