Re: last UPDATE or INSERT time of a table?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: last UPDATE or INSERT time of a table?
Дата
Msg-id 000f01c09761$44b972c0$1001a8c0@archonet.com
обсуждение исходный текст
Ответ на last UPDATE or INSERT time of a table?  (Louis-David Mitterrand <cunctator@apartia.ch>)
Ответы Re: last UPDATE or INSERT time of a table? (not a row!)  (Louis-David Mitterrand <cunctator@apartia.ch>)
Список pgsql-general
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.

- Richard Huxton


В списке pgsql-general по дате отправления:

Предыдущее
От: Alfonso Peniche
Дата:
Сообщение: Re: temp table creation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: temp table creation