Re: Proposal: Store "timestamptz" of database creation on "pg_database" - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Date
Msg-id 20130103143012.GB5506@alvh.no-ip.org
Whole thread Raw
In response to Re: Proposal: Store "timestamptz" of database creation on "pg_database"  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Proposal: Store "timestamptz" of database creation on "pg_database"
List pgsql-hackers
Peter Eisentraut escribió:

> If we're going to store object creation time, I think we should do it
> for all objects, stored in a separate catalog, like pg_depend or
> pg_description, keyed off classid, objectid.  And have a simple C
> function to call to update the information stored there.

+1

We require two catalogs though, one shared, one database-local.

Would we track ctime of subsidiary objects such as constraints etc?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Next
From: Peter Eisentraut
Date:
Subject: Re: dynamic SQL - possible performance regression in 9.2