X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 779D09FB2B7 for ; Wed, 12 Jul 2006 10:12:28 -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 27488-04 for ; Wed, 12 Jul 2006 10:12:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id 6B2909FB0D1 for ; Wed, 12 Jul 2006 10:12:24 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id s49so171309pyc for ; Wed, 12 Jul 2006 06:12:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=LYyzKKp6ysP5kMc4rybL80pIA3leotghNVys8FuR0LamxSDa3QeXbw8/zdK+5AMeINmEioaYWrnunlO4Gtvnw6BHINGeOCy/uDhuOUg146xf6eJ2iRJRPC6YLoZbrmVA3hLamo7NTqBKqfkQfaC0/GexExbg/N4CcY3qYmDGZwk= Received: by 10.35.121.9 with SMTP id y9mr828549pym; Wed, 12 Jul 2006 06:12:22 -0700 (PDT) Received: by 10.35.48.20 with HTTP; Wed, 12 Jul 2006 06:12:21 -0700 (PDT) Message-ID: Date: Wed, 12 Jul 2006 08:12:21 -0500 From: "Jaime Casanova" To: aurora Subject: Re: Unexpected SQL error for UPDATE Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/190 X-Sequence-Number: 25764 > > mydb=# UPDATE users set email_address_text=email_address; > ERROR: invalid page header in block 6776 of relation > "users_email_address_text_key" > users_email_address_text_key sounds a lot like an index... is it an index? if so, what happenned if you REINDEX the table or even DROP and CREATE the index again? it certainly sounds to an index corruption. -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook