Re: Object create date

On Dec 29, 2008, at 12:30 PM, George Pavlov wrote:

> 1. not exactly what you were looking for, but i answer this  
> partially by putting a commented-out CVS expansion tag (e.g. $Id:)  
> in the body of the function so that it gets into the catalog and can  
> be searched:
>
>  CREATE OR REPLACE FUNCTION foo ()
>  RETURNS void AS
>  $BODY$
>  -- $Id: foo.sql,v 1.6 2008/12/23 00:06:52 gpavlov Exp $
>  BEGIN
>  ...
>
> and query it by something like this:
>
>  select
>    routine_name,
>    substring(routine_definition from E'%#\042-- #\044Id: % Exp #\044# 
> \042%' for '#') as cvs_id
>  from information_schema.routines
>  ;
>
> 2. you can also make some inference about the relative timing of  
> object creation based on the OIDs (query pg_catalog.pg_proc rather  
> than information_schema.routines for proc OIDs).

Hmm...  It seems to me that since object creation time, being  
metadata, would be better served being placed in a COMMENT for the  
object.  That would have the added bonus of being able to search in  
one place (pg_description) across all objects of all types for a given  
creation/modification date.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k