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

From Dave Page
Subject Re: Schema unique stamp (OID, MD5?)
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB10475EC@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Schema unique stamp (OID, MD5?)  (Jean-Michel POURE <jm.poure@freesurf.fr>)
Responses Re: Schema unique stamp (OID, MD5?)  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgadmin-hackers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 23 February 2002 19:59
> To: pgadmin-hackers@postgresql.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.

pgadmin-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Schema unique stamp (OID, MD5?)
Next
From: Dave Page
Date:
Subject: Re: ALTER VIEW