Re: Schema unique stamp (OID, MD5?)

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 23 February 2002 19:59
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Schema unique stamp (OID, MD5?)
>
>
> Dear friends,
>
> Do you see an existing way to stamp an existing schema with a
> unique value
> (OID?). This would be very usefull for pgAdmin2 when working
> in development
> teams to decide whether a schema should be reloaded or not.
>
> Using PLbash, this would look like :
> "md5sum < pg_dump --schema-only database_name"
> Are there plans to implement such a feature server-side in C++?

This would be very expensive, even on moderately sized databases wouldn't
it? Why not just check the ctid of the relevant tuple to see if it has
changed since it was last read.

Regards, Dave.