Re: Function tracking

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Function tracking
Дата
Msg-id CAFj8pRB8phQkX_UZp56xN3-8g2bKKO7XR5p7FN0SLAAhR-+OwA@mail.gmail.com
обсуждение исходный текст
Ответ на Function tracking  (Rebecca Clarke <r.clarke83@gmail.com>)
Ответы Re: Function tracking  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: Function tracking  (Glyn Astill <glynastill@yahoo.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Rebecca Clarke
Дата:
Сообщение: Function tracking
Следующее
От: F Wolff
Дата:
Сообщение: Strange ranking with dict_xsyn