| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Yan Chunlu *EXTERN*" <springrider(at)gmail(dot)com>, "pgsql-general General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how could duplicate pkey exist in psql? |
| Date: | 2011-11-17 08:03:44 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C207200DEA@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Szymon Guz | 2011-11-17 08:07:07 | Re: how could duplicate pkey exist in psql? |
| Previous Message | Raghavendra | 2011-11-17 07:59:54 | Re: Foreign Tables |