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

From Merlin Moncure
Subject Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
Date
Msg-id b42b73150704100607g6c709e9dx1074946d43965ea3@mail.gmail.com
Whole thread Raw
In response to Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==  (Markus Schiltknecht <markus@bluegap.ch>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [pgsql-www] Re: programmatic way to fetch latest release for a given major.minor version
Next
From: Dave Page
Date:
Subject: Re: programmatic way to fetch latest release for a given major.minor version