Re: on update of table set timestamp

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: on update of table set timestamp
Дата
Msg-id 4C20888402000025000327DB@gw.wicourts.gov
обсуждение исходный текст
Ответ на on update of table set timestamp  ("Campbell, Lance" <lance@illinois.edu>)
Список pgsql-admin
"Campbell, Lance" <lance@illinois.edu> wrote:

> I want to add a timestamp column to some of my important table
> such that whenever an SQL "update" command is executed on the
> table the "updated_timestamp" timestamp column would be set with
> "now()".

I would write one function which I would bind as a BEFORE UPDATE
trigger to all the tables with the updated_timestamp column.  You
don't need to write a separate function for each table.

-Kevin

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Campbell, Lance"
Дата:
Сообщение: on update of table set timestamp
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?