X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E56619FA195 for ; Wed, 3 May 2006 17:40:32 -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 02933-04 for ; Wed, 3 May 2006 17:40:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 81A959F9C10 for ; Wed, 3 May 2006 17:40:21 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k43KeIfY025743; Wed, 3 May 2006 16:40:18 -0400 (EDT) To: MIlos Prudek cc: pgsql-admin@postgresql.org Subject: Re: missing chunk number 0 for toast value ... In-reply-to: <200605032202.57825.prudek@bvx.cz> References: <200605032202.57825.prudek@bvx.cz> Comments: In-reply-to MIlos Prudek message dated "Wed, 03 May 2006 22:02:57 +0200" Date: Wed, 03 May 2006 16:40:17 -0400 Message-ID: <25742.1146688817@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/31 X-Sequence-Number: 21563 MIlos Prudek writes: > select * from info; > ERROR: missing chunk number 0 for toast value 190937 I was going to suggest the REINDEX, but no luck :-( > What should I do to salvage the table? Find the row containing the busted toast reference, and delete that row (or just UPDATE it with some new value for the toasted column). You can home in on it with the usual sorts of search methods --- look in the PG list archives for previous discussions of locating corrupted rows. regards, tom lane