Re: When the Record Got Updated. - Mailing list pgsql-performance

From A. Kretschmer
Subject Re: When the Record Got Updated.
Date
Msg-id 20070307073053.GB8257@a-kretschmer.de
Whole thread Raw
In response to When the Record Got Updated.  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
List pgsql-performance
am  Wed, dem 07.03.2007, um 12:13:55 +0530 mailte Gauri Kanekar folgendes:
> Hi List,
>
> Can i find out the timestamp when last a record from a table got updated.
> Do any of the pg system tables store this info.

No, impossible. But you can write a TRIGGER for such tasks.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-performance by date:

Previous
From: "Gauri Kanekar"
Date:
Subject: When the Record Got Updated.
Next
From: Richard Huxton
Date:
Subject: Re: Any advantage to integer vs stored date w. timestamp