Please help with this error message

Поиск
Список
Период
Сортировка
От Chris Smith
Тема Please help with this error message
Дата
Msg-id 021701c2f3aa$e7a6bf90$6700000a@KYA
обсуждение исходный текст
Ответы Re: Please help with this error message
Re: Please help with this error message
Список pgsql-general
I posted about this earlier and got no response, but now it's happening
again.  Can someone please help?

We're getting the following error message from PostgreSQL 7.3.2:

    ERROR:  unexpected chunk number 1 (expected 0) for toast value 77579

This error occurs whenever I attempt to SELECT the contents of a bytea field
from this particular record.  It has also occurred in the past, and appears
to happen somewhat randomly among records.  It does not appear to be related
to the content of the data inserted into the database, because we've been
able to retrieve the same actual contents successfully in other records.

The INSERT and UPDATE to add the record and set the contents field work
fine.

Does anyone have any ideas on what I can try to solve this problem?  I can
put in a number of retries, I suppose, but that seems pretty kludgy.

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation


В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: transaction blocking inserts in postgresql 7.3
Следующее
От: Dennis Gearon
Дата:
Сообщение: Re: transaction blocking inserts in postgresql 7.3