Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
Дата
Msg-id b42b73150704100607g6c709e9dx1074946d43965ea3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==  (Markus Schiltknecht <markus@bluegap.ch>)
Список pgsql-general
On 4/10/07, Markus Schiltknecht <markus@bluegap.ch> wrote:
> Robert Treat wrote:
> > Theres this one which uses tcl:
> > https://sourceforge.net/projects/pgdiff
>
> Seems outdated: 2002, PostgreSQL 7.2, ~1500 lines of code. (which I
> don't really understand, I simply don't know TCL, sorry.)
>
> > And this one which is written in perl:
> > http://gborg.postgresql.org/project/pgdiff/projdisplay.php
>
> Yeah, perl is better with me ;-)  Anyway, 2003 also isn't that
> up-to-date either. ~770 lines of code, but that might very well be
> sufficient in many cases.
>
> And as David Fetter pointed out, it's dangerous to rely on such tools,
> as they can never replace a change control process.

no, but it's good to double check your change control process with a
good diff tool.  the sqlmanager tool is pretty good but not perfect.
That being said, I think a hand crafted pl/pgsql script is probably
the way to go.

merlin

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [pgsql-www] Re: programmatic way to fetch latest release for a given major.minor version
Следующее
От: Dave Page
Дата:
Сообщение: Re: programmatic way to fetch latest release for a given major.minor version