Inherits and triggers

Поиск
Список
Период
Сортировка
От Fangbing Wu
Тема Inherits and triggers
Дата
Msg-id 6619c3340603131725w3a5b72a8y1324f9274ec2ab45@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Proposed p.tch for error locations
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [PATCHES] Proposed patch for error locations