Re: How could I find the last modified procedure in the database?
От | Tom Lane |
---|---|
Тема | Re: How could I find the last modified procedure in the database? |
Дата | |
Msg-id | 24408.1321488131@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: How could I find the last modified procedure in the database? (Andreas Kretschmer <akretschmer@spamfence.net>) |
Ответы |
Re: How could I find the last modified procedure in the
database?
|
Список | pgsql-general |
Andreas Kretschmer <akretschmer@spamfence.net> writes: > Dhimant Patel <drp4kri@gmail.com> wrote: >> 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? > Maybe with this query: > select proname from pg_proc order by oid desc limit 1; > but i'm not really sure ... tias (try it and see) The OIDs would tell you the creation order, but they don't change during CREATE OR REPLACE FUNCTION; so depending on what the OP means by "worked on", this query might not be very useful to him. I'd try looking to see which row in pg_proc has the latest xmin. Unfortunately you can't "ORDER BY xmin" ... regards, tom lane
В списке pgsql-general по дате отправления: