Bug report #13542

Postgis view breaks Qgis Server WFS

Added by Henrik Uggla almost 5 years ago. Updated over 3 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:QGIS Server
Affected QGIS version:2.8.2 Regression?:No
Operating System:Ubuntu Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:21584

Description

I've created a view in Postgis 9.3 like this:
SELECT table1.id, table2.geom FROM myschema.table1 JOIN myschema.table2 USING (joincol);
Where id is unique, public has all privileges and only containing point geometries.

When I add this view to a Qgis Server project, and publish it as WFS, GetCapabilities gives me "Internal Server Error". If I remove the view or unpublish it for WFS, GetCapabilities works again. The view is correctly displayed in Qgis Desktop.

History

#1 Updated by Henrik Uggla almost 5 years ago

...and table1 has no geometry.

#2 Updated by Tudor Bărăscu almost 4 years ago

Adding some test data to your issue would greatly improve your chances of getting noticed.
All the best

#3 Updated by Giovanni Manghi over 3 years ago

  • Status changed from Open to Feedback
  • Priority changed from High to Normal
  • Target version deleted (Future Release - High Priority)

Works like a charm here on Ubuntu 16.04 and QGIS 2.18.4

Please leave feedback.

#4 Updated by Giovanni Manghi over 3 years ago

  • Resolution set to worksforme
  • Status changed from Feedback to Closed

Closing for lack of feedback, please reopen if necessary.

Also available in: Atom PDF