Re: Find out when a table was last changed ?

Поиск
Список
Период
Сортировка
От Anand Raman
Тема Re: Find out when a table was last changed ?
Дата
Msg-id 20010228095803.B1495@india-today.com
обсуждение исходный текст
Ответ на Find out when a table was last changed ?  (Markus Fischer <mfischer@josefine.ben.tuwien.ac.at>)
Список pgsql-general
No u need to maintain this information in another column such as
last_update_date which your application should update everyt time u
perform any operation on it..

Hope this helps
Anand

On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote:
>Hi,
>    Is there some kind of command or internal PostgreSql
>column to find out when a table was last changed (INSERT, UPDATE
>or DELETE) on a 7.0.2 Server ?
>
>thanks,
>    Markus
>
>--
>Markus Fischer,  http://josefine.ben.tuwien.ac.at/~mfischer/
>EMail:         mfischer@josefine.ben.tuwien.ac.at
>PGP Public  Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
>PGP Fingerprint: D3B0 DD4F E12B F911 3CE1  C2B5 D674 B445 C227 2BD0

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

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Slowdown problem when writing 1.7million records
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] BLCKSZ 0?