Re: Unexpected SQL error for UPDATE - Mailing list pgsql-sql

From Jaime Casanova
Subject Re: Unexpected SQL error for UPDATE
Date
Msg-id c2d9e70e0607120612g56d97f3cqd0a569a1784fd878@mail.gmail.com
Whole thread Raw
In response to Unexpected SQL error for UPDATE  (aurora <aurora00@gmail.com>)
Responses Re: Unexpected SQL error for UPDATE  (aurora <aurora00@gmail.com>)
List 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


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Unexpected SQL error for UPDATE
Next
From: Mark Stosberg
Date:
Subject: Avoiding RI failure with INSERT ... SELECT FROM