layer screen hangs on database lock

[qgib]

Author Name: Jaap Dekker (Jaap Dekker)
Original Redmine Issue: 7545
Affected QGIS version: master
Redmine category:data_provider/postgis

---

The Qgis 1.8.0 postgis layers dialog does not respond (hangs until the transaction finishes) when a table (not the one that I want to view) in the same database is in use. When I look at the server status window of postgis I see under locks that there is an AccessShareLock that is not granted on the Query
SELECT DISTINCT CASE WHEN upper(geometrytype("the_geom")) IN ('POINT','MULTIPOINT','POINTM','MULTIPOINTM') THEN 'POINT' WHEN upper(geometrytype("the_geom")) IN ('LINESTRING','MULTILINESTRING','LINESTRINGM','MULTILINESTRINGM') THEN 'LINESTRING' WHEN u...

It looks like a process that tries to get the geometry types of all the tables in the database is causing this behaviour. Is it possible to disable this and only do it on the table that I want to view ?

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

End of life notice: QGIS 2.18 LTR
*
Source:*
http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/

---

• resolution was changed from to end of life
• status_id was changed from Open to Closed