On 17 November 2011 06:19, Yan Chunlu <springri...@gmail.com> 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. > > really confused about how could this happen... thanks! >
Hi, could you send us result of the query: select thing_id, '|'||key||'|' from table? Maybe there are some more spaces in the key column which were hidden by table alignment in the client? regards Szymon
