Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL - display different data - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL - display different data
Date
Msg-id 23474.1090454914@sss.pgh.pa.us
Whole thread Raw
In response to SQL - display different data  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: Indexes and Tables: Growth and Treatment
Next
From: Martijn van Oosterhout
Date:
Subject: Re: pgadmin 3