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/
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 |