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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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