Why is there no object create date is the catalogs?

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Why is there no object create date is the catalogs?
Дата
Msg-id CANu8FizWg8GMSmm_d8X0B6uYi7o535f3vqMD3nqFXqrrYB6huA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why is there no object create date is the catalogs?
Re: Why is there no object create date is the catalogs?
Re: Why is there no object create date is the catalogs?
Список pgsql-general

Can anyone tell me why there is no "relcreated" column in pg_class to track the creation date of an object?

It seems to me it would make sense to have one as it would facilitate auditing of when objects are created. In addition, it would also facilitate the dropping of objects that have exceeded a certain age.

EG: SELECT 'DELETE TABLE ' || relname || ';'
      FROM pg_class
     WHERE relkind = 'r'
       AND relcreated > current_timestamp - INTERVAL ' 1 year';

Adding that column should be relatively easy and would not break backwards compatiblity with previous versions.
--
Melvin Davidson

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

Предыдущее
От: William Dunn
Дата:
Сообщение: Re: finding tables about to be vacuum freezed
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Why is there no object create date is the catalogs?