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

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
Date: 2007-04-10 09:24:49
Message-ID: 461B57E1.6070302@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce 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

In response to

Responses

Browse pgsql-announce by date

  From Date Subject
Next Message Merlin Moncure 2007-04-10 13:07:18 Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
Previous Message Robert Treat 2007-04-10 03:06:11 Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==

Browse pgsql-general by date

  From Date Subject
Next Message Tom Allison 2007-04-10 10:01:34 Debian upgrade and PGSQL pid file
Previous Message Listmail 2007-04-10 09:09:50 Re: [GENERAL] programmatic way to fetch latest release for a given major.minor version