The following bug has been logged online:
Bug reference: 2306
Logged by: Andreas Jung
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.9
Operating system: Linux
Description: Duplicate primary key
Details:
Ihave the following table (with 'id' as primary key:
Toolbox2Test=# \d hierarchy
Table "public.hierarchy"
Column | Type |
Modifiers
-------------------------+-----------------------------+----------------
-------------------------+-----------------------------+--------------------
-----------------------
id | integer | not null default
nextval('public.hierarchy_id_seq'::text)
parentid | bigint |
idprodukt | bigint |
bezeichnung | character varying(160) |
neudat | timestamp without time zone |
aedat | timestamp without time zone |
benutzer | character varying(32) |
pos | integer | default 0
linkindex | character varying(20) |
deleted | boolean | default false
visible | boolean |
sorting | boolean |
comment | character varying(265) |
idhierarchy_share | integer |
show_gattung_in_bauplan | boolean | default false
sortierung | character varying(10) |
Indexes:
"hierarchy_pkey" PRIMARY KEY, btree (id)
"hierarchy_deleted_idx" btree (deleted)
"hierarchy_idhierarchy_share_idx" btree (idhierarchy_share)
"hierarchy_idprodukt_idx" btree (idprodukt)
This gives me two rows with the same id=5077:
Toolbox2Test=# select * from hierarchy where id >= 5077 order by id;
id | parentid | idprodukt | bezeichnung
| neudat | aedat
| benutzer | pos | linkindex | deleted | visible | sorting |
comment | idhierarchy_share |
show_gattung_in_bauplan
| sortierung
-------+----------+-----------+---------------------------------------------
--------------------------+----------------------------+--------------------
---
-----+------------------+-----+-----------+---------+---------+---------+---
---------------------------------+-------------------+----------------------
---
+------------
5077 | 4062 | | Präsentieren
| | 2005-11-23
12:03:38.617
969 | RossmyU | 1 | LI353323 | f | | | CSV
import from test_tools.csv | | f
|
5077 | 4062 | | Präsentation
| | 2005-11-24
15:43:50.756
414 | RossmyU | 0 | LI353323 | t | | | CSV
import from test_tools.csv | | t
|
5078 | 4062 | | Rechner
| | 2005-11-23
12:03:38.61
7969 | RossmyU | 2 | LI353324 | f
Search for all rows with id=5077 returns this:
Toolbox2Test=# select * from hierarchy where id = 5077;
id | parentid | idprodukt | bezeichnung | neudat | aedat
| benutzer | pos | linkindex | deleted | visible | sorting |
comment | idhierarchy_share | show_gattung_in_bauplan |
sortierung
------+----------+-----------+--------------+--------+----------------------
------+----------+-----+-----------+---------+---------+---------+----------
----------------------+-------------------+-------------------------+-------
-----
5077 | 4062 | | Präsentieren | | 2005-11-23
12:03:38.617969 | RossmyU | 1 | LI353323 | f | | |
CSV import from test_tools.csv | | f
|
(1 row)
Any idea how to resolve this issue?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
