Inherits and triggers - Mailing list pgsql-interfaces

From Fangbing Wu
Subject Inherits and triggers
Date
Msg-id 6619c3340603131725w3a5b72a8y1324f9274ec2ab45@mail.gmail.com
Whole thread Raw
List pgsql-interfaces
<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 /> 

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Proposed p.tch for error locations
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [PATCHES] Proposed patch for error locations