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. 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:
insert into change_track(10.2, 'plpgsql - add / remove','New plpgsql
stored procedure to add and remove users. adduser(uid,''username''),
That way, if some part of the update fails it all fails and you don't
have any of it in your db.
Then you can just check change_track to see what stuff is in your db.
Plus you can check the scripts into svn for management.
In response to
pgsql-sql by date
|Next:||From: Alvaro Herrera||Date: 2008-12-29 18:38:10|
|Subject: Re: Object create date|
|Previous:||From: Fernando Hevia||Date: 2008-12-29 18:23:15|
|Subject: Object create date|