On Thu, Jan 3, 2013 at 9:18 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> 2013/1/3 Peter Eisentraut <peter_e(at)gmx(dot)net>:
>> On 1/2/13 11:08 PM, Fabrízio de Royes Mello wrote:
>>> The attached patch add a new column into 'pg_database' called
>>> 'datcreated' to store the timestamp of database creation.
>>> If this feature is approved I could extend it to add a column into
>>> 'pg_class' to store creation timestamp too.
>> While I'm entirely in favor of this feature in general, I think this is
>> the wrong way to approach it. It will end up like the CREATE OR REPLACE
>> support: We add it for a few commands in one release, for a few more
>> commands in the next release, for almost all commands in the following
>> release, and now we're still not done.
>> 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.
>> That would also make storing the modification time, which I'd ask for
>> next, easier.
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2013-01-03 14:30:12|
|Subject: Re: Proposal: Store "timestamptz" of database creation on
|Previous:||From: Peter Eisentraut||Date: 2013-01-03 14:18:38|
|Subject: Re: Re: Proposal: Store "timestamptz" of database creation