From: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Schema unique stamp (OID, MD5?) |
Date: | 2002-02-24 15:40:26 |
Message-ID: | 200202241540.g1OFeRFP002560@www1.translationforge |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-02-24 20:05:17 | Re: Escaping quotes and double-quotes problem |
Previous Message | Jean-Michel POURE | 2002-02-24 15:04:45 | Escaping quotes and double-quotes problem |