Re: Unexpected SQL error for UPDATE

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: aurora <aurora00(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Unexpected SQL error for UPDATE
Date: 2006-07-12 13:12:21
Message-ID: c2d9e70e0607120612g56d97f3cqd0a569a1784fd878@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Stosberg 2006-07-12 13:48:37 Avoiding RI failure with INSERT ... SELECT FROM
Previous Message Michael Glaesemann 2006-07-12 12:18:30 Re: Unexpected SQL error for UPDATE