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

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 (view raw or flat)
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

pgsql-novice by date

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

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