Re: Schema unique stamp (OID, MD5?) - Mailing list pgadmin-hackers

From Jean-Michel POURE
Subject Re: Schema unique stamp (OID, MD5?)
Date
Msg-id 200202241540.g1OFeRFP002560@www1.translationforge
Whole thread Raw
In response to Re: Schema unique stamp (OID, MD5?)  (Dave Page <dpage@vale-housing.co.uk>)
List pgadmin-hackers
Dear Dave,

MD5 is a way to create a unique signature of files. For example, it is used
to create unique signatures or RPMs or ISO files.

MD5 could well be used to create a unique signature of the database schema:

In bash :
md5sum < pg_dump --schema-only database_name.

result (example):
9b05A8d545...

md5stamp ("database", db_name) : would update the signature of schema
server-side. The signature would be stored along in pg_database in a "stamp"
field.

Then, in case of multi-user development, pgAdmin2 could be aware of a change
in schema, simply looking at db name "stamp". Maybe there is an easier way to
proceed...

Cheers,
Jean-Michel

pgadmin-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Escaping quotes and double-quotes problem
Next
From: Dave Page
Date:
Subject: Re: Escaping quotes and double-quotes problem