Postgres Pro
Downloads
Home   >   mailing lists

Automatic mod time? - Mailing list pgsql-general

From Steve Lane
Subject Automatic mod time?
Date
Msg-id 200203120610.g2C6AmSc003801@calypso.fmpro.com
Whole thread Raw
In response to Can't get ODBC from Windows to Linux/Postgres to work  ("Jeff Martin" <jeff@dgjc.org>)
Responses Re: Automatic mod time?
List pgsql-general
Tree view
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@fmpro.com
Fax:   (312) 850-3930       Web:   http://www.fmpro.com
=======================================================

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: spanish characters in postgresql
Next
From: Jean-Michel POURE
Date:
Subject: Re: spanish characters in postgresql