how could duplicate pkey exist in psql?

From: Yan Chunlu <springrider(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: how could duplicate pkey exist in psql?
Date: 2011-11-17 05:19:30
Message-ID: CAOA66tE8TqJkQjCra+kNrr8YBS=wXkimN-jtAfNReuX2RAnt_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-11-17 05:31:14 Re: Is it ever necessary to vacuum a table that only gets inserts/updates?
Previous Message John R Pierce 2011-11-17 04:52:26 Re: Is it ever necessary to vacuum a table that only gets inserts/updates?