Postgres Pro
Downloads
Home   >   mailing lists

Re: How could I find the last modified procedure in the database? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: How could I find the last modified procedure in the database?
Date
Msg-id 20111117121539.GC7623@depesz.com
Whole thread Raw
In response to Re: How could I find the last modified procedure in the database?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Pedro Doria Meunier
Date:
Subject: upgrading from 8.3 to 9.0
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: how could duplicate pkey exist in psql?