Re: Version Control?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Peter Fein <pfein(at)pobox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Version Control?
Date: 2005-06-10 16:38:35
Message-ID: 6150c7a4078c06bed63f15bee65ff16e@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Jun 10, 2005, at 11:38 AM, Peter Fein wrote:

>
>> This would obviously have to be pretty damn clever. Amongs the
>> difficulties would be ensuring that the patch applies changes in the
>> correct order (e.g. add column before adding foreign key). It's hard,
>> but I don't believe it's impossible.
>
> As an uninformed, off-the-wall idea, could one compare snapshots of the
> system tables to generate these diffs? I know next-to-nothing about
> these, but it seems like they'd contain the info you'd need.

I think it would be a requirement; I'm not convinced it could be done
just from comparing table definitions. For example, using the table
definitions only, how could you distinguish between renaming the last
column in the table versus dropping the column and adding a new one of
the same type. The target table would be the same, but the semantics of
getting there are not.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-06-10 16:40:00 Re: postgres and xml
Previous Message Edmund Dengler 2005-06-10 16:29:52 Re: Deletes and large tables