From: ashok@kalculate.com <ashok@kalculate.com>
To: pgsql-admin@postgresql.org
To: pgsql-performance@postgresql.org
Subject: invalid page header in block 428 of relation "pg_attribute"
Date: Mon, 26 Feb 2007 00:44:06 -0500
Message-ID: <380-2200721265446950@M2W018.mail2web.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ashok@kalculate.com, pgsql-admin@postgresql.org
Subject: Re: invalid page header in block 428 of relation "pg_attribute"
In-Reply-To: <380-2200721265446950@M2W018.mail2web.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox