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@netmonger.net info@netmonger.net http://www.netmonger.net
Free yourself, free your machine, free the daemon -- http://www.freebsd.org/