Re: Keeping creation time of objects

From: Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
To: daveg <daveg(at)sonic(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, PostgreSQL Hackers ML <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Keeping creation time of objects
Date: 2008-09-09 20:03:56
Message-ID: 1220990636.6935.9.camel@huvostro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-09-09 20:07:22 Re: Common Table Expressions (WITH RECURSIVE) patch
Previous Message Robert Haas 2008-09-09 19:55:12 Re: Keeping creation time of objects