Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Дата
Msg-id CAKFQuwZUbPkjJ4-yw2CHf0WJcK+en8nycKV8e7LT0YgEyJaeAQ@mail.gmail.com
обсуждение исходный текст
Ответ на Add relcreated (timestamp) column to pg_class catalog to record the time an object was created  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
On Wednesday, April 20, 2016, Melvin Davidson <melvin6925@gmail.com> wrote:
I am a bit confused. If this is the correct list for enhancement requests, then why is that not explicitly stated in the list description? Then again, none of the list descriptions mention they are are the correct ones for enhancement requests. However, Customer Feedback ( https://postgresql.uservoice.com/forums/21853-general ) does seem to indicate it and give positive results.
That being said, I would like to put forth a very simple enhancement request.

Add relcreated (timestamp) column to pg_class catalog to record the time an object was created.

Adding relcreated column to pg_class 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';

There are those whom have argued that this would create a problem with table restore from pg_dump, but it does not. Simply make it an attribute of CREATE TABLE. The only requirement would be to insure that the date cannot be a future date.

I'm reasonably certain nothing has changed since the last time you've made this request...

David J.

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created