Re: Function tracking

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Function tracking
Date: 2013-06-07 11:57:46
Message-ID: CAAfz9KMXoE4RJvkwGrjA=kwwcuaBUy7rMwePWcFW8fLWu1v3Ow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2013/6/7 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>

> Hello
>
> 2013/6/7 Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>:
> > Hi all
> >
> > I'm looking for suggestions on the best way to track the updates to a
> > function.
> >
> > We have two databases, Dev & Live, so I want to update Live with just the
> > functions that have been modified in the DEV databas3e.
> > Is there another, easier way to track the updates than manually
> recording it
> > in a document? (I'm trying to eliminate human interference).
> >
>
> There is a few tools
>
>
> http://stackoverflow.com/questions/4804779/how-to-check-difference-between-two-databases-in-postgressql
> http://pgdiff.sourceforge.net/
>
> But I prefer editing files for storing schema and function
> definitions. And I use a git. I dislike direct object modifying via
> tools like pgAdmin and similar.
>
Same here.

--
// Dmitriy.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Dahn 2013-06-07 12:10:27 Full text search, SQL functions, and the planner
Previous Message Beena Emerson 2013-06-07 11:53:18 excute function before DROP EXTENSION