Обсуждение: Bug #423: unable to do selects on certain fields in large tables

Поиск
Список
Период
Сортировка

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

От
pgsql-bugs@postgresql.org
Дата:
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