Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0E0DB633033 for ; Tue, 17 Feb 2009 12:08:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21806-01 for ; Tue, 17 Feb 2009 12:08:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by mail.postgresql.org (Postfix) with ESMTP id 0B29E632F75 for ; Tue, 17 Feb 2009 12:08:17 -0400 (AST) Received: from webmail.zmi.at (websrv1.zmi.at [212.69.162.199]) by mailsrv1.zmi.at (Postfix) with ESMTP id 9387F405D; Tue, 17 Feb 2009 17:08:15 +0100 (CET) Received: from phpmailer ([195.202.170.131]) by webmail.zmi.at with HTTP (PHPMailer); Tue, 17 Feb 2009 17:08:15 +0100 Date: Tue, 17 Feb 2009 17:08:15 +0100 To: Achilleas Mantzios , pgsql-admin@postgresql.org From: Michael Monnerie Subject: Re: 8.3.5 broken after power fail Message-ID: X-Priority: 3 X-Mailer: PHPMailer [version 1.71] X-Mailer: FeLaMiMail In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/122 X-Sequence-Number: 31343 "Michael Monnerie" schrieb: > select * from dbmail_messageblks where messageblk_idnr not in (3904492); >=20 > That helps. Slowly I may be able to find all broken entries. Is there a more > automated way? Now I already have select * from dbmail_messageblks where messageblk_idnr not in (3904492,3904495,3904496,3904499,3904500,3904501,3904503); ERROR: unexpected chunk number 1 (expected 0) for toast value 1460210 in pg_toast_1281127 Is there a way to find out what "toast value 1460210" stands for? I'd like to find the connection between messageblk_idnr and that toast value, as = it's not easy to find that. mfg zmi