I'm not an expert on this, but here's my best guess:
Triggers don't get inherited between tables because a trigger has to be
associated with a specific table. CREATE TRIGGER does not accept the
table* syntax normall associated with globbing or specificying
subclasses. Thus, there is no way for a trigger to be inherited.
Question: How difficult would it be for this to be added?
--
Martin Jackson: mhjacks(at)nwa(dot)quik(dot)com
====================================
My Other Computer is Also a Linux Box