| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How could I find the last modified procedure in the database? |
| Date: | 2011-11-16 16:10:05 |
| Message-ID: | 4EC3E05D.8080808@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On 11/16/11 8:00 AM, Dhimant Patel 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?
as far as I know, nothing like that is stored, unless you log DDL
operations, and timestamp your logs, in which case it would be in the
logfiles.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2011-11-16 16:30:55 | Re: How could I find the last modified procedure in the database? |
| Previous Message | David Schnur | 2011-11-16 16:04:59 | How and when are encoding DLLs used on Windows? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christine Penner | 2011-11-16 16:22:15 | Postgres windows user |
| Previous Message | Dhimant Patel | 2011-11-16 16:00:11 | How could I find the last modified procedure in the database? |