Re: Knowing when a row was last updated

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Antony Paul <antonypaul24(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Knowing when a row was last updated
Date: 2004-11-17 14:33:38
Message-ID: 20041117143337.GA77078@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 17, 2004 at 07:43:31PM +0530, Antony Paul wrote:

> Is it possible to know when a row was last updated. Using 7.3.3.

Add a TIMESTAMP or TIMESTAMP WITH TIME ZONE column to the table and
use a trigger to update it.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2004-11-17 14:56:57 Re: TSearch2: Problems with compound words and stop words
Previous Message Antony Paul 2004-11-17 14:13:31 Knowing when a row was last updated