From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
---|---|
To: | ksharma6(at)metlife(dot)com |
Cc: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13324: Database returing incorrect results on querying slect clause |
Date: | 2015-05-22 00:17:31 |
Message-ID: | CAEepm=1ar4++Hc+ww0JCWi1AOKaSfc0VxByP4+9kcLpHgp85UQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, May 21, 2015 at 2:23 PM, <ksharma6(at)metlife(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 13324
> Logged by: Krishna Sharma
> Email address: ksharma6(at)metlife(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Sharma, Krishna Kumar | 2015-05-22 00:20:52 | Re: BUG #13324: Database returing incorrect results on querying slect clause |
Previous Message | Sharma, Krishna Kumar | 2015-05-22 00:14:14 | Re: BUG #13324: Database returing incorrect results on querying slect clause |