Re: Schema unique stamp (OID, MD5?)

Поиск
Список
Период
Сортировка
От Jean-Michel POURE
Тема Re: Schema unique stamp (OID, MD5?)
Дата
Msg-id 200202241540.g1OFeRFP002560@www1.translationforge
обсуждение исходный текст
Ответ на Re: Schema unique stamp (OID, MD5?)  (Dave Page <dpage@vale-housing.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Escaping quotes and double-quotes problem
Следующее
От: Dave Page
Дата:
Сообщение: Re: Escaping quotes and double-quotes problem