"Wang, Mary Y" <mary.y.wang@boeing.com> writes:
> However, when I type
> "Select * from bug where bug_id=166"
> No rows are returned.
This sounds to me like the bug_pkey index is corrupted. You might try
REINDEXing it. If that fixes it, better look for reasons why it got
corrupted (bad RAM or some such would be my first bet).
regards, tom lane