From: | Louis-David Mitterrand <cunctator(at)apartia(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: last UPDATE or INSERT time of a table? (not a row!) |
Date: | 2001-02-15 16:52:07 |
Message-ID: | 20010215175207.A4526@apartia.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
--
THESEE: Mais te condamner tu m'as trop engag.
Jamais pre en effet fut-il plus outrag ?
(Phdre, J-B Racine, acte 4, scne 3)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-15 16:52:53 | Re: regular expression substittion function? |
Previous Message | pejac | 2001-02-15 16:49:00 | Re:TODO ITEM about substitution |