The following bug has been logged online:
Bug reference: 3567
Logged by: sapna kapoor
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.9
Operating system: RHEL 5.0 AS
Description: invalid page header in block XXXXof relation
Details:
We have database of 300 tables ,
some tables are giving error :
ERROR: invalid page header in block 32655 of relation "AAAA" while
accessing.
Some are giving
ERROR: could not access status of transaction 1778384896
DETAIL: could not open file "pg_clog/06A0": No such file or directory
We are in the process of loading data from distibuted locations. We are
importing data onto this server from the export files taken from distributed
locations.
---------------------------(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
