Bug report #6510
PostGIS tables with both a Geometry and a TopoGeometry column
|Affected QGIS version:||1.8.0||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||Yes||Resolution:||fixed|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||15727|
When a PostGIS table has both a geometry and a topogeometry column qgis only sees the geometry column.
CREATE TABLE t (g geometry, tg topogeometry); CREATE TABLE t2 (tg topogeometry);
Then "Add PostGIS layer", find the "t" table and you'll only see the "g" column, find the "t2" table and you'll see the "tg" column.
I've also tried to switch the order in which topogeometry and geometry columns are added but it's still only the geometry that gets considered when both are available.
May be related to #4532 but I'm not sure yet
#1 Updated by Sandro Santilli about 10 years ago
Note that if geometry_columns lookup fails (I temporarly renamed it for testing it) then both columns are shown.
It's a case of metadata lookup automatically becoming authoritative, triggering skipping of further lookup.
This is also when the "only check geometry_columns" option is unselected.
So yes I confirm it is related with #4532