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
wherebug_id=166" statement. Another problem I have is that a block of records (consecutive records) are disappeared
frommy database probably because of the index is corrupted. Is there any other way that I get those records back
withoutdoing a restore?
Thanks.
Mary
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, July 21, 2004 5:09 PM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] SQL - display different data
"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