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

Mathieu Ouellette ouellette.mathieu at gmail.com
Fri Nov 4 11:15:24 PDT 2011


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111104/32fa338a/attachment.html>


More information about the Qgis-user mailing list