Postgresql duplicate primary key
<p>I am woking on PG <code>9.2.14</code> on our production server I am facing some random issue.</p>

<p>Let's say its a table named <code>users</code> and <code>id</code> is the primary key in it.</p>

<p>When I am trying to reindex the table it give me following error:-</p>

<pre><code>ERROR:  could not create unique index "users_pkey"
DETAIL:  Key (id)=(339) is duplicated.
</code></pre>

<p>When I am trying to fetch user with the <code>339</code> id, there is no record. I am not sure if its PG's bug or I am doing something wrong.</p>

<p>Any one have faced such kind of problem?</p>