Re: last UPDATE or INSERT time of a table? (not a row!)

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: last UPDATE or INSERT time of a table? (not a row!)
Date: 2001-02-15 21:45:02
Message-ID: 3A8C4DDE.4BA36880@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Louis-David Mitterrand wrote:
>
> On Thu, Feb 15, 2001 at 03:09:16PM -0000, Richard Huxton wrote:
> > From: "Louis-David Mitterrand" <cunctator(at)apartia(dot)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?
>

You could check the date on the file. But a vacuum might alter that.

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Sawtell 2001-02-15 22:01:01 Name list for testing / demo.
Previous Message Richard Huxton 2001-02-15 20:04:44 Re: last UPDATE or INSERT time of a table? (not a row!)