Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EEED69FB47A; Mon, 26 Feb 2007 01:56:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 93817-05; Mon, 26 Feb 2007 01:56:41 -0400 (AST) X-Greylist: delayed 00:12:43.808975 by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from xsmtp03.mail2web.com (xsmtp03.mail2web.com [168.144.250.223]) by postgresql.org (Postfix) with ESMTP id 55ED59FB3E0; Mon, 26 Feb 2007 01:56:42 -0400 (AST) Received: from [168.144.108.18] (helo=M2W018.mail2web.com) by xsmtp03.mail2web.com with smtp (Exim 4.63) (envelope-from ) id 1HLYec-00061J-VO; Mon, 26 Feb 2007 00:44:12 -0500 Message-ID: <380-2200721265446950@M2W018.mail2web.com> X-Priority: 3 Reply-To: ashok@kalculate.com X-Originating-IP: 59.176.106.240 X-URL: http://mail2web.com/ From: "ashok@kalculate.com" To: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org Date: Mon, 26 Feb 2007 00:44:06 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Subject: invalid page header in block 428 of relation "pg_attribute" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/319 X-Sequence-Number: 24784 Hello List, I'm using postgresql 7=2E4 on FC4=2E When i run following query on postgresql prompt, it gives error=2E indse96=3D# CREATE TEMP TABLE aggregate AS ( SELECT vc=5Fvo= uchno ,vc=5Fsrno,vc=5Ftype ,vc=5Fvouchdt,trim(''),vc=5Fdescrip, ( = CASE WHEN (vc=5Fdr=5Fcr=3D'D') THEN vc=5Famount ELSE 0 END ) AS debit , = ( CASE WHEN (vc=5Fdr=5Fcr=3D'C') THEN vc=5Famount ELSE 0 END) AS credit = =20 FROM voucher WHERE vc=5Fvouchdt >=3D '2005-04-01' AND vc=5Fvouchdt <=3D '2006-03-31' AND trim(vc=5Fcode)=3D'100006016' ORDER BY= vc=5Fvouchdt,vc=5Fvouchno ); ERROR: invalid page header in block 428 of relation "pg=5Fattribute" I'm not able to understand why this error is come=2E plz=2E help me=2E Thanks Ashok -------------------------------------------------------------------- mail2web=2Ecom =96 Enhanced email for the mobile individual based on Micro= soft=AE Exchange - http://link=2Email2web=2Ecom/Personal/EnhancedEmail