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

From Markus Schiltknecht
Subject Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
Date
Msg-id 461B57E1.6070302@bluegap.ch
Whole thread Raw
In response to Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Hi,

thanks for the links. I've had a quick look at the first two and comment
my findings:

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.

Regards

Markus


pgsql-general by date:

Previous
From: Listmail
Date:
Subject: Bad plan using join on VALUES
Next
From: Tom Allison
Date:
Subject: Debian upgrade and PGSQL pid file