Re: Keeping creation time of objects - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Keeping creation time of objects
Date
Msg-id 1220990636.6935.9.camel@huvostro
Whole thread Raw
In response to Re: Keeping creation time of objects  (daveg <daveg@sonic.net>)
Responses Re: Keeping creation time of objects
List pgsql-hackers
On Tue, 2008-09-09 at 12:40 -0700, daveg wrote:

> I'd be very interested in seeing a last schema modification time for pg_class
> objects. I don't care about it being preserved over dump and restore as my
> use case is more to find out when a table was created with a view to finding
> out if it is still needed.

Isn't it easier to find out if it is still needed by looking if it is
still used, say from pg_stat_user_tables ?

-----------------
Hannu




pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Keeping creation time of objects
Next
From: Tom Lane
Date:
Subject: Re: Common Table Expressions (WITH RECURSIVE) patch