| 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: | 200203120610.g2C6AmSc003801@calypso.fmpro.com |
| Views: | Whole Thread | Raw Message | 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 |