[Qgis-user] Identify and Selection errors with PostGIS layer

[Dennis M. Linton]

Mathieu;

Not sure if this will help but I get the sort of errors you describe if
I do not have the correct layer activated (selected).

- Dennis
-- 
Dennis M. Linton, P.Eng.
Tel: +1 (613) 473-1015
Cell: +1 (705) 312-1336
Skype: thedmlinton




On Fri, 2011-11-04 at 14:15 -0400, Mathieu Ouellette wrote: 

> Hi,
> 
> 
> I'm new on this list. It's the first time I set up a connection to a
> PostgreSQL database. I've loaded a PostGIS layer with a geography
> type. I'm using QGIS version 1.7.0 (French). When I try to use the
> identify tool or try to select features I get errors. Can you help me?
> This is the error I get when try to select a point:
> 
> 
> 1 cursor states lost.
> SQL: declare qgisf13 binary cursor for select
> "mention_id",st_asbinary("geog") from "sh_men"."mentions_qgis" where
> "geog" && setsrid('BOX3D(-73.3194457756198688 51.4414069720229392,
> -73.2060621086736916 51.5642392778812919)'::box3d,4326) and
> intersects("geog",setsrid('BOX3D(-73.3194457756198688
> 51.4414069720229392, -73.2060621086736916
> 51.5642392778812919)'::box3d,4326)) and ("code_esp"  LIKE 'AMLA')
> Résultat: 7 (ERREUR:  la fonction intersects(geography, geometry)
> n'existe pas
> LINE 1: ...1086736916 51.5642392778812919)'::box3d,4326) and
> intersects...
>                                                              ^
> HINT:  Aucune fonction ne correspond au nom donné et aux types
> d'arguments.
> Vous devez ajouter des conversions explicites de type.
> )
> 
> 
> Thanks,
> 
> 
> Mathieu
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111104/9ad35d1c/attachment.html>