Automatic mod time?

From: Steve Lane <slane(at)fmpro(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Automatic mod time?
Date: 2002-03-11 21:50:42
Message-ID: B8B282D2.9F1F%slane@fmpro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems like this should be simple but I haven¹t found any obvious pointer
in the documents.

I need a timestamp field that¹s updated every time a record is touched, to
show the last mod date.

I have this working with a trigger just fine. But this means adding a new
trigger for each table that needs this.

Is there an easier way?

Thanks,

Steve

=======================================================
Steve Lane

Vice President
Chris Moyer Consulting, Inc.
833 West Chicago Ave Suite 203

Voice: (312) 433-2421 Email: slane(at)fmpro(dot)com
Fax: (312) 850-3930 Web: http://www.fmpro.com
=======================================================

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2002-03-11 22:07:19 Re: pg_toast table growth out of control
Previous Message Booth, Robert 2002-03-11 21:40:56 fmgr_info: function 0: cache lookup failed