[Qgis-user] intersects(geography, geometry) doesn't exists

sebastien.porta at s-porta.fr sebastien.porta at s-porta.fr
Mon Jan 16 05:28:42 PST 2012


Hi there,

I'm trying to add a postgis layer... (the layer is a table with a 
geometry field "position")
When i try to click on a geometry i've this message :

1 cursor states lost.

SQL: declare qgisf1 binary cursor for select 
"id",st_asbinary("position"),"dt_ajout"::text,"lat"::text,"long"::text,"comment"::text,"id_etat"::text,"id_statut"::text,"dt_statut"::text,"id_puce"::text,"nb_personnes"::text,"comment_interne"::text 
from "public"."signalisation" where "position" && 
setsrid('BOX3D(39.7235820895520533 -5.4107462686566228, 
54.8435820895520578 9.7092537313433809)'::box3d,4326) and 
intersects("position",setsrid('BOX3D(39.7235820895520533 
-5.4107462686566228, 54.8435820895520578 9.7092537313433809)'::box3d,4326))

Résultat: 7 (ERREUR: la fonction intersects(geography, geometry) 
n'existe pas

LINE 1: ...20895520578 9.7092537313433809)'::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.

)


And i don't know what i have to do to resolve it....
Anyone have an idea ?

Thx in advance,
Sebastien





More information about the Qgis-user mailing list