Re: BUG #2341: Wrong results when using index - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2341: Wrong results when using index
Date
Msg-id 8182.1142892604@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2341: Wrong results when using index  ("Slavcho Ivanov" <slavcho@gmail.com>)
List pgsql-bugs
"Slavcho Ivanov" <slavcho@gmail.com> writes:
> The query was as simple as possible
>   "select * from data where "SensorID" = 18",
> and the result had a couple of rows where SensorID was NOT 18, but 3.

That's not too surprising if the index had gotten corrupted somehow,
but since you haven't provided any details that would let someone else
reproduce the problem, there's not much we can do with this report :-(

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem in connection
Next
From: Tom Lane
Date:
Subject: Re: BUG #2342: Extremely bad performance on a specific query, compared to 7.4