Adam Witney <awitney@sgul.ac.uk> 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