Re: Last modification date for Triggers, functions, tables .... - Mailing list pgsql-novice

From Didier Gasser-Morlay
Subject Re: Last modification date for Triggers, functions, tables ....
Date
Msg-id l2m608b66ce1005010153h429b109w257f30f6162e8403@mail.gmail.com
Whole thread Raw
In response to Re: Last modification date for Triggers, functions, tables ....  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Last modification date for Triggers, functions, tables ....  (Bob McConnell <rmcconne@lightlink.com>)
List pgsql-novice


On 30 April 2010 20:40, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Didier Gasser-Morlay <didiergm@gmail.com> writes:
> Is there a way to determine the last modification date of the script of a
> function or trigger,
> Same question for relations and attributes  ?

>No, that's not tracked.  You could get a rough idea from the xmin of the
>relevant catalog rows, but we don't store actual timestamps.

>                       regards, tom lane

Too bad, I'll have to find another way then,

thanks

regards, Didier

pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: returning more than one value from a function
Next
From: Jasen Betts
Date:
Subject: Re: Last modification date for Triggers, functions, tables ....