Re: BUG #13324: Database returing incorrect results on querying slect clause - Mailing list pgsql-bugs

On Thu, May 21, 2015 at 2:23 PM,  <ksharma6@metlife.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13324
> Logged by:          Krishna Sharma
> Email address:      ksharma6@metlife.com
> PostgreSQL version: Unsupported/Unknown
> Operating system:   Windows 2003
> Description:
>
> Hi PostgreSQL team, we are suing PostGreSQL 8.2.
>
> When I run a query in database like
> select * from dn_case where id= 1234.
>
> it returns 2 rows with different ids.
>
> How is this happening?

With no other information, my first guess would be that an index has
somehow become corrupted.

> it seems the database is corrupt. Please suggest a soluton for this issue.

The solution may be to rebuild the index:

http://www.postgresql.org/docs/8.2/static/sql-reindex.html

(That is a very old PostgreSQL release which is no longer supported
because it reached 'EOL' status in 2011:
http://www.postgresql.org/support/versioning/ ).

--
Thomas Munro
http://www.enterprisedb.com