Re: SQL - display different data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL - display different data
Date: 2004-07-22 00:08:34
Message-ID: 23474.1090454914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-07-22 00:24:06 Re: pgadmin 3
Previous Message Thomas F.O'Connell 2004-07-21 23:50:07 Re: Indexes and Tables: Growth and Treatment