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

On Wednesday, April 20, 2016, Melvin Davidson <melvin6925(at)gmail(dot)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
> <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.