Bug #423: unable to do selects on certain fields in large tables - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #423: unable to do selects on certain fields in large tables
Date
Msg-id 200108231841.f7NIf4321705@hub.org
Whole thread Raw
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: timestamps cannot be created without time zones
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #424: JDBC driver security issue.