Quick Links

How could I find the last modified procedure in the database?

From:	Dhimant Patel <drp4kri(at)gmail(dot)com>
To:	pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject:	How could I find the last modified procedure in the database?
Date:	2011-11-16 16:00:11
Message-ID:	CAJfXtLcpC89EY-wMecQs_uMprtgUxyh7VomJgGNXQQQgW4N1cw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin pgsql-general

I have postgres *(PostgreSQL) 9.0.3 running.*
I also created several procedures/functions and now I don't remember the
last procedure I worked on! - I thought I could always get this from
metadata.

Now I'm stuck - couldn't find this details anywhere in catalog tables!

Is there anyway I can get this information?

Thanks,
DP.

Responses

Re: How could I find the last modified procedure in the database? at 2011-11-16 16:10:05 from John R Pierce
Re: How could I find the last modified procedure in the database? at 2011-11-16 16:30:55 from Andreas Kretschmer
Re: How could I find the last modified procedure in the database? at 2011-12-10 09:00:26 from Jasen Betts

Browse pgsql-admin by date

	From	Date	Subject
Next Message	David Schnur	2011-11-16 16:04:59	How and when are encoding DLLs used on Windows?
Previous Message	MirrorX	2011-11-15 22:09:28	Re: cancelled queries on standby

Browse pgsql-general by date

	From	Date	Subject
Next Message	John R Pierce	2011-11-16 16:10:05	Re: How could I find the last modified procedure in the database?
Previous Message	Clark C. Evans	2011-11-16 15:16:34	Re: CLONE DATABASE (with copy on write?)