Re: Unexpected SQL error for UPDATE

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: Unexpected SQL error for UPDATE
Дата
Msg-id c2d9e70e0607120612g56d97f3cqd0a569a1784fd878@mail.gmail.com
обсуждение исходный текст
Ответ на Unexpected SQL error for UPDATE  (aurora <aurora00@gmail.com>)
Ответы Re: Unexpected SQL error for UPDATE
Список 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 по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Unexpected SQL error for UPDATE
Следующее
От: Mark Stosberg
Дата:
Сообщение: Avoiding RI failure with INSERT ... SELECT FROM