Re: Function tracking - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Function tracking
Date
Msg-id CAFj8pRB8phQkX_UZp56xN3-8g2bKKO7XR5p7FN0SLAAhR-+OwA@mail.gmail.com
Whole thread Raw
In response to Function tracking  (Rebecca Clarke <r.clarke83@gmail.com>)
Responses Re: Function tracking  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: Function tracking  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-general
Hello

2013/6/7 Rebecca Clarke <r.clarke83@gmail.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
>
>
>
>
>
>
>


pgsql-general by date:

Previous
From: Rebecca Clarke
Date:
Subject: Function tracking
Next
From: F Wolff
Date:
Subject: Strange ranking with dict_xsyn