From: | "ashok(at)kalculate(dot)com" <ashok(at)kalculate(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
Subject: | invalid page header in block 428 of relation "pg_attribute" |
Date: | 2007-02-26 05:44:06 |
Message-ID: | 380-2200721265446950@M2W018.mail2web.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Goran Rakic | 2007-02-26 09:05:51 | Disconnecting non active (IDLE ) users |
Previous Message | Ben Trewern | 2007-02-25 22:58:15 | Re: Fastest DB restore options |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-02-26 08:56:33 | Re: Very slow bytea data extraction |
Previous Message | Peter Kovacs | 2007-02-25 22:11:01 | Re: Two hard drives --- what to do with them? |