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

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How could I find the last modified procedure in the database?
Date: 2011-12-10 09:00:26
Message-ID: jbv73a$mfp$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 2011-11-16, Dhimant Patel <drp4kri(at)gmail(dot)com> wrote:

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

if you generated any exceptions during your work on the functions you
may find evidence in the database log.

--
⚂⚃ 100% natural

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Yves NOLEN 2011-12-12 11:32:10 Problems while restoring databases
Previous Message Rural Hunter 2011-12-09 07:19:42 hot standby failed to start

Browse pgsql-general by date

  From Date Subject
Next Message Frank Lanitz 2011-12-10 09:09:15 Re:
Previous Message Craig Ringer 2011-12-10 05:45:30 Re: Question regarding authentication/login