Skip site navigation (1) Skip section navigation (2)

Re: Object create date

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: "'Scott Marlowe'" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Object create date
Date: 2008-12-29 21:20:21
Message-ID: F10D306EE342433CB6F00B0B67ED0DBD@iptel.com.ar (view raw or flat)
Thread:
Lists: pgsql-sql
> -----Mensaje original-----
> De: pgsql-sql-owner(at)postgresql(dot)org 
> [mailto:pgsql-sql-owner(at)postgresql(dot)org] En nombre de Scott Marlowe
> 
> On Mon, Dec 29, 2008 at 11:23 AM, Fernando Hevia 
> <fhevia(at)ip-tel(dot)com(dot)ar> wrote:
> > Hi list,
> >
> > I'm having a hard time trying to find out if the latest 
> patches have 
> > been applied to my application (uses lots of pgplsql functions).
> > Does Postgres store creation date and/or modification date 
> for tables, 
> > functions and other objects?
> > It would help me a lot if I could query each object when it was 
> > created. Is this information available on 8.3? Where should I look?
> 
> PostreSQL doesn't track this kind of thing for you.  

Too bad it doesn't. I think it would be quite useful that the database saved
the creation time of at least some objects.


> An easy method to implement yourself is to create a table to track 
> such changes, and add a line to insert data into that table.
> 
> create table change_track (version numeric(12,2) primary key, 
> title text, summary text);
> 
> Then in a script, always update like so:
> 
> begin;
> insert into change_track(10.2, 'plpgsql - add / remove','New 
> plpgsql stored procedure to add and remove users.  
> adduser(uid,''username''), deluser(uid)');
> 
> create function....
> 
> commit;
> 

Although it's not a solution for an already messed-up database it is an
interesting solution to consider for the future.
Thanks Scott.

Regards,
Fernando.


In response to

pgsql-sql by date

Next:From: Fernando HeviaDate: 2008-12-29 21:20:26
Subject: Re: Object create date
Previous:From: George PavlovDate: 2008-12-29 20:30:48
Subject: Re: Object create date

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group