Bug report #11311

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

Added by Moreno Comelli over 9 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:19607

Description

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);

History

#1 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF