Re: last UPDATE or INSERT time of a table? (not a row!) - Mailing list pgsql-general

From Louis-David Mitterrand
Subject Re: last UPDATE or INSERT time of a table? (not a row!)
Date
Msg-id 20010215175207.A4526@apartia.ch
Whole thread Raw
In response to Re: last UPDATE or INSERT time of a table?  ("Richard Huxton" <dev@archonet.com>)
List pgsql-general
On Thu, Feb 15, 2001 at 03:09:16PM -0000, Richard Huxton wrote:
> From: "Louis-David Mitterrand" <cunctator@apartia.ch>
>
> > Is there a way to check the last time a table was UPDATEd or INSERTEd?
> > Is there a timestamp somewhere in the system tables?
> >
> > (If not that would be really useful to help in web page cacheing and
> > expiration to learn if any change occured on the data)
> >
> > Thanks in advance,
>
> You can set up a trigger. See my previous post RFC: automatic
> "lastchange"... for some more info, or search the archives.

Yes, I have read that thread qnd implemented a similar trigger in the
past.

What I meant to do is detect a change at the _table_ level, not the row
level. Is there such a field somewhere in the pg_tables?

--
    THESEE: Mais � te condamner tu m'as trop engag�.
            Jamais p�re en effet fut-il plus outrag� ?
                                          (Ph�dre, J-B Racine, acte 4, sc�ne 3)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: regular expression substittion function?
Next
From:
Date:
Subject: Re:TODO ITEM about substitution