Better yet, define a trigger so you and/or other programmers don't have
to worry about including that field in every update.
-Jonathan
----- Original Message -----
From: Anand Raman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 8:28 PM
Subject: Re: Find out when a table was last changed ?
> No u need to maintain this information in another column such as
> last_update_date which your application should update everyt time u
> perform any operation on it..
>
> Hope this helps
> Anand
>
> On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote:
> >Hi,
> > Is there some kind of command or internal PostgreSql
> >column to find out when a table was last changed (INSERT, UPDATE
> >or DELETE) on a 7.0.2 Server ?
> >
> >thanks,
> > Markus
> >
> >--
> >Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/
> >EMail: [EMAIL PROTECTED]
> >PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
> >PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
