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