X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E75EDD1B195 for ; Wed, 7 Jul 2004 18:38:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55188-06 for ; Wed, 7 Jul 2004 21:38:31 +0000 (GMT) Received: from andrea.pop4.net (andrea.pop4.net [216.234.109.11]) by svr1.postgresql.org (Postfix) with SMTP id 4CDF4D1B18F for ; Wed, 7 Jul 2004 18:38:26 -0300 (ADT) Received: (qmail 9100 invoked by uid 1008); 7 Jul 2004 21:38:24 -0000 Received: from cdsmith@twu.net by www.pop4.net with qmail-scanner-0.96 (uvscan: v4.1.40/v4156. . Clean. Processed in 0.659154 secs); 07 Jul 2004 21:38:24 -0000 Received: from unknown (HELO KYA) (69.171.228.185) by 0 with SMTP; 7 Jul 2004 21:38:23 -0000 Message-ID: <003601c4646b$03e516c0$6f00000a@KYA> From: "Chris Smith" To: "Diogo Biazus" , References: Subject: Re: ERROR: missing chunk number 0 for toast value 14227980 Date: Wed, 7 Jul 2004 15:40:24 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS, SUBJ_HAS_UNIQ_ID X-Spam-Level: X-Archive-Number: 200407/268 X-Sequence-Number: 62867 Diogo Biazus wrote: > Hi, can anyone help me with this error: ERROR: missing chunk number 0 > for toast value 14227980 > > Is there a solution? When I ran into that error, it was apparently due to bugs in the Linux IDE driver for our disk. In your case, it may be something different; I can't say for sure. Once the primary problem is solved, the only solution seems to be to dump the table, drop it, and then restore from the dump. -- www.designacourse.com The Easiest Way to Train Anyone... Anywhere. Chris Smith - Lead Software Developer/Technical Trainer MindIQ Corporation