Adam Witney <awitney@xxxxxxxxxx> writes: > I don't know, so posting your question to the list. I meant to ask last > night in fact, should i be worried as to why this occurred? Yeah, you should, but since you hadn't given us any context about the problem I figured you only cared about a quick fix. Otherwise I would have suggested saving a physical copy of the broken index and table for analysis. The symptoms imply that some of the index entries were pointing to rows that didn't belong to them (ie, rows with a different bioassay_id value than what the index entry said). The only ways I know of to explain that involve database or system crashes ... you have any recently? regards, tom lane
