Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C74839FB38B for ; Tue, 10 Oct 2006 03:48:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94414-02 for ; Tue, 10 Oct 2006 03:48:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id 0EBDC9FB221 for ; Tue, 10 Oct 2006 03:48:46 -0300 (ADT) Received: (qmail 5211 invoked by uid 540); 10 Oct 2006 06:36:39 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(153.19.179.26):. Processed in 0.070613 secs); 10 Oct 2006 06:36:39 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 10 Oct 2006 06:36:38 -0000 Message-ID: <452B423F.8050108@informatyka.gdansk.pl> Date: Tue, 10 Oct 2006 08:48:31 +0200 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: MG CC: pgsql-admin@postgresql.org Subject: Re: ERROR: invalid page header in block References: <001201c6eb73$7f2845f0$340aa8c0@geisslinger> In-Reply-To: <001201c6eb73$7f2845f0$340aa8c0@geisslinger> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.291 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/62 X-Sequence-Number: 23365 I've tried to do this same thing i "psql" client. It was worked properly. I'm not sure, but maybe Your table on disk is corrupted. Does it work simply: select oid from public.lock and select * from public.lock and SELECT "oid", * FROM "public"."lock" ? Your query will be faster makinkg it that way: SELECT COUNT(*) AS total FROM "public"."lock" "lock" is not very fine name for table (for ex. You can do inside transaction: LOCK table public.lock IN SHARE MODE). Greetings Adam MG wrote: > Hello, > > I have the following error and I'm a bit worried: > > SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "public"."lock") > AS sub > >-> ERROR: invalid page header in block 0 of relation "lock" > >delete from lock where bildschirmnr=16 > >-> ERROR: invalid page header in block 0 of relation "lock" > >Any ideas whats going on? > >Thanks for any help > >Michaela >