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