Skip site navigation (1) Skip section navigation (2)

Re: Last modification date for Triggers, functions, tables ....

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Last modification date for Triggers, functions, tables ....
Date: 2010-04-30 18:40:51
Message-ID: 13425.1272652851@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Didier Gasser-Morlay <didiergm(at)gmail(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Jasen BettsDate: 2010-05-01 03:33:34
Subject: Re: Last modification date for Triggers, functions, tables ....
Previous:From: Didier Gasser-MorlayDate: 2010-04-30 17:19:47
Subject: Last modification date for Triggers, functions, tables ....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group