Bug report #2488

Unable to add filter to PostGIS layer while "Render" option is turned off

Added by bstempi - over 10 years ago. Updated over 9 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:worksforme
Crashes QGIS or corrupts data: Copied to github as #:12548

Description

I found that I was not able to add filters on PostGIS layers while the "Render" option in the lower right hand corner is unchecked. The idea was to add a layer, stop the rendering, add a filter on my layer, and then to render (to save bandwidth).

After unchecking "Render," I right-clicked on the layer, and went to Properties-> General-> Query Builder. I received a database error for every WHERE clause I wrote. After clicking "cancel," I checked the "Render" option, navigated back into the Query Builder, and was able to use WHERE clauses that previously failed.

History

#1 Updated by Jürgen Fischer over 10 years ago

not reproducable here.

#2 Updated by bstempi - over 10 years ago

I'll attempt to replicate on another system as soon as possible.

#3 Updated by Giovanni Manghi over 10 years ago

please leave further feedback or close if not replicable

#4 Updated by Volker Fröhlich over 9 years ago

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

Please re-open if problem is still there.

Also available in: Atom PDF