Thread: Inherits and triggers

Inherits and triggers

From
"Fangbing Wu"
Date:
<br />I have a situation where I want all of my tables to have a timestamp field that is updated to the<br
/>current_timestampwhenever a column in a row is updated. For a single table, I could do this<br />with a trigger. So I
thoughtof using table inheritance and created the trigger on the base <br />table. But then, the trigger is not fired
whenupdating rows in children tables.<br /><br />Does anyone knows of a better way to achieve this without having to
createthe trigger<br />for every table? I'm writing a library and the tables are not known at the time of writing <br
/>thelibrary.<br /><br />Any suggestions are appreciated!<br /><br />Fangbing Wu<br /><br />