It's been a long time but I just clean-built QGIS from master branch
(commit 8145f8f9276bb0b71ffb076e9b4115d800c41747) to find that the
TopoViewer of DBManager is failing to provide proper layers.
The TopoViewer creates a layer tree composed by a top group
named after the target topology and 3 sub-groups:
- Faces
- face_mbr
- face
- face_seed
- Nodes
- node
- node_id
- Edges
- edge
- directed_edge
- edge_id
Of the 8 layers, only the ones under "Faces" work, while the others
not only don't show anything but do not even present the user with
a right-click->Properties (or double-click) menu to inspect
properties. The right-click menu shows only a few entries
(copy layer, rename layer, duplicate layer) and show no geometry type.
Do you have any idea what could cause this ?
The logs, for one of the layers, report:
src/providers/postgres/qgspostgresprovider.cpp:100 :
(QgsPostgresProvider) [3ms] URI: dbname='p' port=5432 key='edge_id'
estimatedmetadata=true srid=4167 type=LineString checkPrimaryKeyUnicity='1'
table="test0"."edge_data" (geom) sql=
src/providers/postgres/qgspostgresprovider.cpp:149 :
(QgsPostgresProvider) [0ms] Connection info is dbname='p' port=5432
src/providers/postgres/qgspostgresprovider.cpp:150 :
(QgsPostgresProvider) [0ms] Geometry column is: geom
src/providers/postgres/qgspostgresprovider.cpp:151 :
(QgsPostgresProvider) [0ms] Schema is: test0
src/providers/postgres/qgspostgresprovider.cpp:152 :
(QgsPostgresProvider) [0ms] Table name is: edge_data
src/providers/postgres/qgspostgresprovider.cpp:153 :
(QgsPostgresProvider) [1ms] Query is: "test0"."edge_data"
src/providers/postgres/qgspostgresprovider.cpp:154 :
(QgsPostgresProvider) [0ms] Where clause is:
src/providers/postgres/qgspostgresconn.cpp:168 : (connectDb) [0ms]
Using cached connection for dbname='p' port=5432
src/providers/postgres/qgspostgresprovider.cpp:1145 :
(hasSufficientPermsAndCapabilities) [0ms] Checking for permissions on the
relation
src/providers/postgres/qgspostgresprovider.cpp:3526 :
(getGeometryDetails) [0ms] Getting geometry column: SELECT
upper(type),srid,coord_dimension FROM geometry_columns WHERE
f_table_name='edge_data' AND f_geometry_column='geom' AND f_table_schema='test0'
src/providers/postgres/qgspostgresprovider.cpp:3528 :
(getGeometryDetails) [1ms] Geometry column query returned 1 rows
src/providers/postgres/qgspostgresprovider.cpp:3769 :
(getGeometryDetails) [1ms] Detected SRID is 4167
src/providers/postgres/qgspostgresprovider.cpp:3770 :
(getGeometryDetails) [0ms] Requested SRID is 4167
src/providers/postgres/qgspostgresprovider.cpp:3771 :
(getGeometryDetails) [0ms] Detected type is 2
src/providers/postgres/qgspostgresprovider.cpp:3772 :
(getGeometryDetails) [0ms] Requested type is 2
src/providers/postgres/qgspostgresprovider.cpp:3780 :
(getGeometryDetails) [0ms] Spatial column type is Geometry
src/providers/postgres/qgspostgresprovider.cpp:747 : (loadFields) [0ms]
Loading fields for table edge_data
src/providers/postgres/qgspostgresprovider.cpp:1344 :
(determinePrimaryKey) [2ms] Checking whether SELECT count(*) FROM pg_inherits
WHERE inhparent='"test0"."edge_data"'::regclass is a parent table
src/providers/postgres/qgspostgresprovider.cpp:1349 :
(determinePrimaryKey) [0ms] Retrieving first primary or unique index: SELECT
indexrelid FROM pg_index WHERE indrelid='"test0"."edge_data"'::regclass AND
(indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END
LIMIT 1
src/providers/postgres/qgspostgresprovider.cpp:1352 :
(determinePrimaryKey) [1ms] Got 1 rows.
src/providers/postgres/qgspostgresprovider.cpp:1442 :
(determinePrimaryKey) [0ms] Retrieving key columns: SELECT attname,attnotnull
FROM pg_index,pg_attribute WHERE indexrelid=14313569 AND indrelid=attrelid AND
pg_attribute.attnum=any(pg_index.indkey)
src/providers/postgres/qgspostgresprovider.cpp:1444 :
(determinePrimaryKey) [0ms] Got 1 rows.
--strk;
() Free GIS & Flash consultant/developer
/\ https://strk.kbt.io/services.html
_______________________________________________
QGIS-Developer mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
