Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 7E51B35F309 for ; Wed, 16 Nov 2011 12:37:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 93303-09 for ; Wed, 16 Nov 2011 16:37:33 +0000 (UTC) X-Greylist: delayed 00:06:19.636999 by SQLgrey-1.8.0-rc2 Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id A8D0235F308 for ; Wed, 16 Nov 2011 12:37:33 -0400 (AST) Received: from mailout04.ims-firmen.de ([213.174.32.250]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RQiOE-000366-18 for pgsql-general@postgresql.org; Wed, 16 Nov 2011 16:31:12 +0000 Received: from mailin01.ims-firmen.de ([192.168.1.110]) by mailout02.ims-firmen.de with esmtp (envelope-from ) id 1RQiO1-0002Rx-43 for pgsql-general@postgresql.org; Wed, 16 Nov 2011 17:30:57 +0100 Received: from [87.170.211.89] (helo=a-kretschmer.de) by mailin01.ims-firmen.de with esmtpsa (TLSv1:AES256-SHA:256) (envelope-from ) id 1RQiO0-0004Ys-UZ for pgsql-general@postgresql.org; Wed, 16 Nov 2011 17:30:57 +0100 Received: from kretschmer by a-kretschmer.de with local (Exim 4.69) (envelope-from ) id 1RQiNz-0003Yv-RF for pgsql-general@postgresql.org; Wed, 16 Nov 2011 17:30:55 +0100 Date: Wed, 16 Nov 2011 17:30:55 +0100 From: Andreas Kretschmer To: pgsql-general@postgresql.org Subject: Re: How could I find the last modified procedure in the database? Message-ID: <20111116163055.GA13297@tux> References: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B 3B86 4DB3 D9EE 7F45 84DA X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! X-Lugdd: Gerd Kube X-Info: My name is root. Just root. And I am licensed to kill -9 User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201111/591 X-Sequence-Number: 182161 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? 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) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°