[Qgis-developer] Problem with Postgis 2.0 Views and picking (info-tool)

[Sandro Santilli]

On Wed, Jan 18, 2012 at 07:34:13PM +0100, Andreas Neumann wrote:
> Meanwhile I tested with the same data on Postgis 1.5.3. Everything works
> fine with Postgis 1.5.3
> 
> So apparently there are issues with Postgis 2.0. I followed Denis'
> advice and deliberately set the SRID of the_geom in my view to "-1" with
> SetSRID(the_geom,-1), voila, it works!
> 
> To me this sounds like a bug. QGIS somehow intersects (for picking and
> selecting) an SRID of -1 with the layers SRID (in my case 21781) and
> results in a mixed SRID error.
> 
> Jürgen or Strk - can you help with this issue?

Unknown srid became 0 in PostGIS-2.0.
The correct way to deal with unknown srids is to NOT specify them at all.

Check out the actual query being produced by qgis in the log window and
try it manually. Let us know.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html