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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
