<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.3">
</HEAD>
<BODY>
Mathieu;<BR>
<BR>
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).<BR>
<BR>
- Dennis<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>
--
Dennis M. Linton, P.Eng.
Tel: +1 (613) 473-1015
Cell: +1 (705) 312-1336
Skype: thedmlinton
</PRE>
<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
On Fri, 2011-11-04 at 14:15 -0400, Mathieu Ouellette wrote: <BR>
<BLOCKQUOTE TYPE=CITE>
Hi,<BR>
<BR>
<BR>
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:<BR>
<BR>
<BR>
1 cursor states lost.<BR>
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')<BR>
Résultat: 7 (ERREUR: la fonction intersects(geography, geometry) n'existe pas<BR>
LINE 1: ...1086736916 51.5642392778812919)'::box3d,4326) and intersects...<BR>
^<BR>
HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments.<BR>
Vous devez ajouter des conversions explicites de type.<BR>
)<BR>
<BR>
<BR>
Thanks,<BR>
<BR>
<BR>
Mathieu
<PRE>
_______________________________________________
Qgis-user mailing list
<A HREF="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</A>
<A HREF="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</A>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>