Re: SQL - display different data

Tom,
Thanks for the info. After I did vacuum of that table, I was able to get the row return by this "Select * from bug where bug_id=166" statement. Another problem I have is that a block of records (consecutive records) are disappeared from my database probably because of the index is corrupted. Is there any other way that I get those records back without doing a restore?

Thanks.
Mary

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, July 21, 2004 5:09 PM
To: Wang, Mary Y
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] SQL - display different data

"Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)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