Re: how could duplicate pkey exist in psql?

Yan Chunlu wrote:
> recently I have found several tables has exactly the same pkey,  here
is the definition:
> "diggcontent_data_account_pkey" PRIMARY KEY, btree (thing_id, key)
>
>
> the data is like this:
>
>    159292 | funnypics_link_point       | 41
> | num
>    159292 | funnypics_link_point       | 40
> | num
>
>
> I could not even update this record.

It could be a software bug or something else, but did you ever
restore the database after a storage problem?

This has happened to me once:
http://archives.postgresql.org/pgsql-general/2010-02/msg00971.php

Yours,
Laurenz Albe