Re: Object create date

> -----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.