DB Manager doesn't import PostGIS data in view with dblink

[qgib]

Author Name: Moreno Comelli (Moreno Comelli)
Original Redmine Issue: 11311
Affected QGIS version: master
Redmine category:db_manager

---

I tried to import in QGIS a view with a PostGIS geometry column, which data are obtained from a second db (using dblink in Postgres).
It works through the normal 'Add PostGIS layer', not through DB Manager.

CREATE OR REPLACE VIEW my_view AS
SELECT id, geomfromtext('POINT('|| x_coo || ' ' || y_coo || ')', 3003)
FROM dblink('host=127.0.0.1 port=5432 dbname=xxx user=xxx password=xxx',
'SELECT id, x_coo, y_coo FROM my_table;') AS m (id numeric, x_coo numeric, y_coo numeric);

[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