Skip site navigation (1) Skip section navigation (2)

Re: Schema unique stamp (OID, MD5?)

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 (view raw or flat)
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

In response to

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-02-24 20:05:17
Subject: Re: Escaping quotes and double-quotes problem
Previous:From: Jean-Michel POUREDate: 2002-02-24 15:04:45
Subject: Escaping quotes and double-quotes problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group