Re: BUG #8382: Duplicate primary key

gsstark(at)gmail(dot)com schrieb am 14.08.2013 12:44:40:
> select ctid,xmin,xmax,primarykey from tab where primarykey =
'duplicatevalue'
traviclinkengine=# select ctid,xmin,xmax,* from cluster_ressource where
clusterknoten_id = 1 and ressource_id = 10;
ctid | xmin | xmax | clusterknoten_id | ressource_id | anzahl
-------+-----------+------+------------------+--------------+--------
(1,9) | 308561268 | 0 | 1 | 10 | 0
(3,9) | 308561268 | 0 | 1 | 10 | 0
(2 Zeilen)

> And also show the \d tab output?
traviclinkengine=# \d cluster_ressource
Tabelle »public.cluster_ressource«
Spalte | Typ | Attribute
------------------+----------+-----------
clusterknoten_id | bigint | not null
ressource_id | bigint | not null
anzahl | smallint | not null
Indexe:
"cluster_ressource_pkey" PRIMARY KEY, btree (clusterknoten_id,
ressource_id)
"cl_res_res_fkind" btree (ressource_id)
Fremdschlüssel-Constraints:
"cl_res_clkn_fk" FOREIGN KEY (clusterknoten_id) REFERENCES
clusterknoten(id) ON DELETE RESTRICT
"cl_res_res_fk" FOREIGN KEY (ressource_id) REFERENCES ressource(id) ON
DELETE RESTRICT

> And can you load the pageinspect contrib module in this database?
Yes. At least I think I've just done it. :-)

Curd