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
=======================================================
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 |