"Ed L." <[EMAIL PROTECTED]> writes:
> How do I fix this 7.4.6 issue short of initdb?
> invalid page header in block 110 of relation "pg_statistic"
> I looked at the block via pg_filedump (included below), and it
> does not appear to me to be corrupted, so not sure what I would
> zero out, if anything.
Seems odd to me too ... but pg_statistic doesn't contain any
irreplaceable data. See if you can TRUNCATE it. If so, do
an ANALYZE to repopulate it. I don't recall if 7.4 has any
special hoops you'd have to jump through to truncate a system
catalog ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
