From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Function tracking |
Date: | 2013-06-07 10:44:50 |
Message-ID: | CAFj8pRB8phQkX_UZp56xN3-8g2bKKO7XR5p7FN0SLAAhR-+OwA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Regards
Pavel
>
> Many thanks in advance
>
> Rebecca
>
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | F Wolff | 2013-06-07 10:48:56 | Strange ranking with dict_xsyn |
Previous Message | Rebecca Clarke | 2013-06-07 10:30:18 | Function tracking |