On 17 November 2011 06:19, Yan Chunlu <springrider@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 | numI 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?regardsSzymon
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 | numI could not even update this record.really confused about how could this happen... thanks!
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных