Re: Date created for tables

On 12/23/19 6:14 PM, Ron wrote:
> On 12/23/19 7:01 PM, Bruce Momjian wrote:
>> On Thu, Dec 5, 2019 at 05:10:20PM +0000, Chloe Dives wrote:
>>> Having moved to PostgreSQL from Oracle a few years ago I have been generally
>>> very impressed by Postgres, but there are a few things that I still miss. One
>>> of those is being able to see the created and last modified dates for database
>>> objects.
>>>
>>>
>>>
>>> Is this something that has been considered for implementation?
>> I wrote a blog about this:
>>
>> https://momjian.us/main/blogs/pgblog/2017.html#November_21_2017
>
> You all are *grossly* over-complicating this.

Not really. This discussion has come up before and it starts with the
simple case of timestamp the initial CREATE. This would suffice for some
folks. However, it then progresses into a request for full object audit
system. I understand why there is no great desire to start down this
path by the developers, they know the pressure would be on to expand the
code. As Fabrízio mentions in another post this is something that could
be covered in an extension. FYI, I do it by using Sqitch for my schema
object creation.

>
> By creation time, "we DBAs" think the time we ran "CREATE object", not
> when pg_dump, pg_basebackup and pg_update ran.
>
> Likewise, modification time is when we last ran an ALTER command ran,
> not when VACUUM ran (that's tracked elsewhere) or DML ran.
>
> That's all.
>
> --
> Angular momentum makes the world go 'round.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com