PostGIS tables with both a Geometry and a TopoGeometry column

[qgib]

Author Name: Sandro Santilli (@strk)
Original Redmine Issue: 6510
Affected QGIS version: 1.8.0
Redmine category:data_provider/postgis
Assignee: Sandro Santilli

---

When a PostGIS table has both a geometry and a topogeometry column qgis only sees the geometry column.
To reproduce:

 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 #14449 but I'm not sure yet

[qgib]

Author Name: Sandro Santilli (@strk)

---

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 #14449

[qgib]

Author Name: Sandro Santilli (@strk)

---

1.8.0 is also affected. I'm working on a fix for master.

---

• version was changed from master to 1.8.0
• assigned_to_id was configured as Sandro Santilli

[qgib]

Author Name: Sandro Santilli (@strk)

---

Will be fixed in master by pulling this: #291
I could work on backporting to 1.8.0 branch if you see fit.

---

• done_ratio was changed from 0 to 90
• pull_request_patch_supplied was changed from 0 to 1

[qgib]

Author Name: Sandro Santilli (@strk)

---

Patch pulled in master. Thanks jef!

---

• resolution was changed from to fixed
• status_id was changed from Open to Closed
• done_ratio was changed from 90 to 100