Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 423BCE3C1F1 for ; Thu, 17 Nov 2011 08:16:02 -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 87036-10 for ; Thu, 17 Nov 2011 12:15:56 +0000 (UTC) Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E5C90E3C1EF for ; Thu, 17 Nov 2011 08:15:55 -0400 (AST) Received: from andy.depesz.com ([88.198.47.100] helo=depesz.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RR0sk-0008HC-Dd for pgsql-general@postgresql.org; Thu, 17 Nov 2011 12:15:54 +0000 Received: from andy.depesz.com ([88.198.47.100] helo=depesz.com) by depesz.com with esmtpa (Exim 4.77) (envelope-from ) id 1RR0sV-0006Re-GM; Thu, 17 Nov 2011 13:15:39 +0100 Date: Thu, 17 Nov 2011 13:15:39 +0100 From: hubert depesz lubaczewski To: Tom Lane Cc: Andreas Kretschmer , pgsql-general@postgresql.org Subject: Re: How could I find the last modified procedure in the database? Message-ID: <20111117121539.GC7623@depesz.com> Reply-To: depesz@depesz.com References: <20111116163055.GA13297@tux> <24408.1321488131@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <24408.1321488131@sss.pgh.pa.us> User-Agent: Mutt/1.5.21 (2010-09-15) 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/629 X-Sequence-Number: 182199 On Wed, Nov 16, 2011 at 07:02:11PM -0500, Tom Lane wrote: > I'd try looking to see which row in pg_proc has the latest xmin. > Unfortunately you can't "ORDER BY xmin" ... order by age(xmin) ? Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/