Re: BUG #8382: Duplicate primary key - Mailing list pgsql-bugs

From Curd Reinert
Subject Re: BUG #8382: Duplicate primary key
Date
Msg-id OF97BE5DA6.D521218F-ONC1257BC7.003D7EEB-C1257BC7.003F5DC6@ppi.de
Whole thread Raw
In response to Re: BUG #8382: Duplicate primary key  (Greg Stark <stark@mit.edu>)
List pgsql-bugs
gsstark@gmail.com schrieb am 14.08.2013 12:44:40:
> select ctid,xmin,xmax,primarykey from tab where primarykey =3D=20
'duplicatevalue'
traviclinkengine=3D# select ctid,xmin,xmax,* from cluster=5Fressource where=
=20
clusterknoten=5Fid =3D 1 and ressource=5Fid =3D 10;
 ctid  |   xmin    | xmax | clusterknoten=5Fid | ressource=5Fid | 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=3D# \d cluster=5Fressource
Tabelle =BBpublic.cluster=5Fressource=AB
      Spalte      |   Typ    | Attribute
------------------+----------+-----------
 clusterknoten=5Fid | bigint   | not null
 ressource=5Fid     | bigint   | not null
 anzahl           | smallint | not null
Indexe:
    "cluster=5Fressource=5Fpkey" PRIMARY KEY, btree (clusterknoten=5Fid,=20
ressource=5Fid)
    "cl=5Fres=5Fres=5Ffkind" btree (ressource=5Fid)
Fremdschl=FCssel-Constraints:
    "cl=5Fres=5Fclkn=5Ffk" FOREIGN KEY (clusterknoten=5Fid) REFERENCES=20
clusterknoten(id) ON DELETE RESTRICT
    "cl=5Fres=5Fres=5Ffk" FOREIGN KEY (ressource=5Fid) REFERENCES ressource=
(id) ON=20
DELETE RESTRICT

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

Curd

pgsql-bugs by date:

Previous
From: Greg Stark
Date:
Subject: Re: BUG #8382: Duplicate primary key
Next
From: David Fetter
Date:
Subject: Re: BUG #8381: data base inconsistancy