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

From: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Last modification date for Triggers, functions, tables ....
Date: 2010-05-01 08:53:01
Message-ID: l2m608b66ce1005010153h429b109w257f30f6162e8403@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 30 April 2010 20:40, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>

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

thanks

regards, Didier

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bob McConnell 2010-05-01 11:40:39 Re: Last modification date for Triggers, functions, tables ....
Previous Message Jasen Betts 2010-05-01 03:46:30 Re: returning more than one value from a function