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