Bug report #6176
When adding postgis layer the build query feature doesn't work
| 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 over 12 years ago
- Status changed from Open to Feedback
what version of QGIS? what platform? what PostGIS version?
#2
Updated by Nikos Ves over 12 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 over 12 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 over 12 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 12 years ago
- Target version set to Version 2.0.0
#6
Updated by Nikos Ves about 12 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 almost 12 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.