Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Date
Msg-id CANu8Fiw2e8-26Us=G6YLX_0BP14APpnbKniXuhuM8iBvHxb+xQ@mail.gmail.com
Whole thread Raw
In response to Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
List pgsql-general

"Speaking blindly here but given that we now have event triggers I'm even more inclined to simply tell people to setup user-space tables and event triggers to do whatever they want.  Is there any reason that combination cannot solve the problems being brought up?  I get the desirability of having something in-core but this seems like a perfect problem for which PGXN should be the solution."

Wekk, yes and no. To use event triggers requires that a user first create their own audit table, then create a function to process the event, and finally create the event trigger. That works fine for the single database situation, but when you have hundreds of servers and databases to monitor (as I did), it makes the implementation a bit more daunting. Whereas having relcreatedat would mean "no muss, no fuss". :)


--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Alex Ignatov
Date:
Subject: Re: Initdb --data-checksums by default
Next
From: Melvin Davidson
Date:
Subject: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created