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

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

From: Mary Anderson <maryfran(at)demog(dot)berkeley(dot)edu>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Last modification date for Triggers, functions, tables ....
Date: 2010-05-01 17:30:35
Message-ID: 4BDC653B.6040802@demog.berkeley.edu (view raw or flat)
Thread:
Lists: pgsql-novice
Jasen Betts wrote:
> On 2010-04-30, Didier Gasser-Morlay <didiergm(at)gmail(dot)com> wrote:
>   
>> --001636833a443f05eb0485777373
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> Hi,
>>
>> Is there a way to determine the last modification date of the script of a
>> function or trigger,
>> Same question for relations and attributes  ?
>>     
>
> AFAIK no built-in way.
>
>   
>> My purpose would be to be able to list all DDL changes having occurred since
>> a certain date, that would be very useful to me during application
>> development with a fast evolving db schema.
>>     
>
> if you do nightly --schema-only  snapshots using pg_dump and store them over
> each other in source code managemnt system (git, subversion, CVS, RCS, 
> codesafe - what-ever) 
>
> Then you can pull a diff from that and see the changed.
>
>   
Actually, there is an open source application called 'post facto' which 
takes two postgres schemas and produces an SQL change set of operations 
which will transform one into the other.  You might want to run this 
nightly and incorporate it into your version control system.

Mary

In response to

pgsql-novice by date

Next:From: Lonni J FriedmanDate: 2010-05-01 22:49:10
Subject: Re: returning more than one value from a function
Previous:From: Leif Biberg KristensenDate: 2010-05-01 11:43:44
Subject: Re: returning more than one value from a function

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