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

In 7.0 it is rather obvious. In 7.1 they moved to a number based
scheme. I suggested they make a symlink with the name of the table
pointing at the numbered file, but I don't think anyone paid attention.

The info is in one of the pg_???? tables, I don't know which one
offhand.

Louis-David Mitterrand wrote:
>
> On Thu, Feb 15, 2001 at 04:45:02PM -0500, Joseph Shraibman wrote:
> > > 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.
>
> Hmm, I see many files in /var/lib/postgres/data/base but how do I
> recognize which file contains what table?
>
> --
> ARICIE: De votre injuste haine il n'a pas hérité ;
> Il ne me traitait point comme une criminelle.
> (Phèdre, J-B Racine, acte 5, scène 3)

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