From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Hackers ML <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Keeping creation time of objects |
Date: | 2008-09-09 19:46:04 |
Message-ID: | 1220989565.2711.194.camel@laptop.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 2008-09-09 at 15:36 -0400, Tom Lane wrote:
> why would creation time (as opposed to any other time, eg last schema
> modification, last data modification, yadda yadda) be especially
> significant?
Hmm, those would be cool, too.
Seriously, I believe we can get last data modification from filesystem
(if it is keeping of course), but we cannot get the creation time --
that's why I am talking about the creation time.
It would be useful when a DBA is not sure whether (s)he created the
object on a known time, or it was not restored from backups correctly or
not.
> Would you expect it to be preserved over dump/restore?
No. If we are talking about "creation time", then it means we should not
preserve it, IMHO.
> How about every other object type in the system?
I'm talking about every object.
Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2008-09-09 19:55:12 | Re: Keeping creation time of objects |
Previous Message | daveg | 2008-09-09 19:40:59 | Re: Keeping creation time of objects |