Обсуждение: on update of table set timestamp

Поиск
Список
Период
Сортировка

on update of table set timestamp

От
"Campbell, Lance"
Дата:

PostgreSQL 8.4

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()”.  Is there a way to do this?  I know I could go through and change my SQL all over the place to update a column “updated_timestamp” with “now()” but it would be faster if there was some way to set a constraint and/or default value on the field.  Is this possible.  I don’t really want to do store procedures.

 

Thanks,

 

Lance Campbell

Software Architect/DBA/Project Manager

Web Services at Public Affairs

217-333-0382

 

Re: on update of table set timestamp

От
"Kevin Grittner"
Дата:
"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