Bug report #4291

zoom to layer extent does not work with postgis 2.0.0svn tables

Added by Daniel Araujo Miranda about 12 years ago. Updated about 12 years ago.

Affected QGIS version: Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data: Copied to github as #:14228


#1 Updated by Daniel Araujo Miranda about 12 years ago

how to reproduce:
add a layer from postgis into qgis
right click on the layer name and select "zoom to layer extent"
nothing happens

Bug is not always reproducible. Seems to work on generic geometry layers, but not with geometry(Polygon,4326), for example. (postgis 2 notation).

Ubuntu 11.04
qgis 1.7 wroclaw (1.7.0~natty1, MD5sum: ae3fc6b49d8e82acd8a97d515bad00bc)
postgis 2.0.0 svn 7856, Last Changed Date: 2011-09-15 14:43:57
postgresql 9.1

#2 Updated by Steven Mizuno about 12 years ago

This appears to be a PostGIS 2.0 problem - does st_estimated_extent(schema,table,geom_column) return a reasonable value for the tables in question?

#3 Updated by Daniel Araujo Miranda about 12 years ago

Steven, as you said, st_estimated extent was returning nonsense.

I reported it as postgis bug #1200, which I just checked and seems to be fixed in r7868 (see http://trac.osgeo.org/postgis/ticket/1200).

Thanks for taking a look at this.
I did not close it saturday because if the postgis guys would not get around it quickly, I believe qgis would have to implement a workaround.

How do I close this bug?

#4 Updated by Giovanni Manghi about 12 years ago

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

closed now. Fixed upstream.

Also available in: Atom PDF