Tom Lane wrote:
Hmm. Maybe we need something more like a "lint check" for tables, ie
run through and look for visibly corrupt data, such as obviously
impossible lengths for varlena fields.
Come to think of it, didn't someone already write something close to
this a few years ago?
Sounds like pgfsck:
http://svana.org/kleptog/pgsql/pgfsck.html
Unfortunately it doesn't seem to have been updated to work with recent
versions of PG (> 7.3)
-Neil
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend