Bug report #6176

When adding postgis layer the build query feature doesn't work

Added by Nikos Ves about 7 years ago. Updated over 6 years ago.

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

Description

When adding a postgis layer the build query test always returns 0 (rows). The same where clause from inside postgis returns valid numbers of rows

History

#1 Updated by Giovanni Manghi about 7 years ago

  • Status changed from Open to Feedback

what version of QGIS? what platform? what PostGIS version?

#2 Updated by Nikos Ves about 7 years ago

checked against latested git build as well with qgis 1.8.

PostgreSQL 9.1.4 with (POSTGIS="2.1.0SVN" GEOS="3.3.4-CAPI-1.7.3" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.7.3")

Ubuntu 12.04

#3 Updated by Giovanni Manghi about 7 years ago

Nikos Ves wrote:

checked against latested git build as well with qgis 1.8.

PostgreSQL 9.1.4 with (POSTGIS="2.1.0SVN" GEOS="3.3.4-CAPI-1.7.3" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.7.3")

Ubuntu 12.04

it used to work in qgis 1.7.4?

#4 Updated by Giovanni Manghi about 7 years ago

Nikos Ves wrote:

checked against latested git build as well with qgis 1.8.

PostgreSQL 9.1.4 with (POSTGIS="2.1.0SVN" GEOS="3.3.4-CAPI-1.7.3" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.7.3")

Ubuntu 12.04

I just tested and it works fine with both qgis 1.8 and master.

#5 Updated by Paolo Cavallini about 7 years ago

  • Target version set to Version 2.0.0

#6 Updated by Nikos Ves almost 7 years ago

I just realised that the layer that the problems is "view" of a proper table

eg

CREATE OR REPLACE VIEW test_view as select * from geodb;

add the view table to layer and the bug(?) should surface.

In another note, a view should be considered as a proper table from withing qgis or not?

#7 Updated by Giovanni Manghi over 6 years ago

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

CREATE OR REPLACE VIEW test_view as select * from geodb;

add the view table to layer and the bug(?) should surface.

it works fine here

In another note, a view should be considered as a proper table from withing qgis or not?

they are supported, but you will need a primary key anyway.

please reopen if necessary or attach sample data/steps to replicate the issue.

Also available in: Atom PDF