Postgres Pro
Downloads
Home   >   mailing lists

invalid page header in block 428 of relation "pg_attribute" - Mailing list pgsql-performance

From ashok@kalculate.com
Subject invalid page header in block 428 of relation "pg_attribute"
Date
Msg-id 380-2200721265446950@M2W018.mail2web.com
Whole thread Raw
List pgsql-performance
Tree view 
Hello List,

I'm using postgresql 7.4 on FC4.

When i run following query on postgresql prompt, it gives error.

indse96=# CREATE TEMP TABLE aggregate AS  (             SELECT   vc_vouchno
,vc_srno,vc_type  ,vc_vouchdt,trim(''),vc_descrip,              ( CASE WHEN
(vc_dr_cr='D') THEN vc_amount ELSE 0 END ) AS debit ,                   (
CASE WHEN (vc_dr_cr='C') THEN vc_amount  ELSE 0 END) AS credit
FROM voucher                    WHERE vc_vouchdt >= '2005-04-01' AND
vc_vouchdt <= '2006-03-31' AND  trim(vc_code)='100006016' ORDER BY
vc_vouchdt,vc_vouchno );
ERROR:  invalid page header in block 428 of relation "pg_attribute"

I'm not able to understand why this error is come.
plz. help me.

Thanks
Ashok

--------------------------------------------------------------------
mail2web.com – Enhanced email for the mobile individual based on Microsoft®
Exchange - http://link.mail2web.com/Personal/EnhancedEmail

pgsql-performance by date:

Previous
From: "Peter Kovacs"
Date:
Subject: Re: Two hard drives --- what to do with them?
Next
From: Richard Huxton
Date:
Subject: Re: Very slow bytea data extraction