Bug #423: unable to do selects on certain fields in large tables

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Bug #423: unable to do selects on certain fields in large tables
Дата
Msg-id 200108231841.f7NIf4321705@hub.org
обсуждение исходный текст
Список pgsql-bugs
dave miller (dmiller@dyrectmedia.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
unable to do selects on certain fields in large tables

Long Description
In a table of about 300 MG, I am unable browse or select the text field - xml (holding a large XML document ) of any
record. We noticed the problem after deleting about 50,000 records from the 100,000+ record table.  We can select any
otherfield but the xml field, but not any whole record. 

Sample Code
PostgreSQL said: ERROR: chunk 1 for toast value 1227454 appears multiple times

No file was uploaded with this report

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: timestamps cannot be created without time zones
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #424: JDBC driver security issue.