<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=FR link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Hi every one<br>
<br>
I'm using PostGis 1.5.3 and QGis 1.7 and I've troubles adding postgis layers to
QGis. <br>
<br>
In the error message given by QGis when I try to add postgis layers, there's
this query which doesn't work any longer although it used to work with PostGis
1.5.2: <br>
----------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>select
"oid",asbinary("geom",'NDR') from
"cadastre"."commune" where "geom" && <u>setsrid('BOX3D</u>(794270.8532559783197939
6312919.8975825672969222, 860762.6940280217677355
6362904.3300199424847960)'::box3d,2154);<b><span style='font-weight:bold'> <br>
------------<br>
</span></b>After different tests I've found that I must use the geometry()
function to force the first parameter of the setsrid() function to convert into
"geometry" type. <br>
----------<br>
select "oid",asbinary("geom",'NDR') from
"cadastre"."commune" where "geom" && <u>setsrid(geometry</u>('BOX3D(794270.8532559783197939
6312919.8975825672969222, 860762.6940280217677355
6362904.3300199424847960)'::box3d),2154); <br>
----------<br>
<br>
Is it a Postgis or a Qgis problem? How can I fix that? Since I've upgraded to
Postgis 1.5.3, all my QGis projects are not working any more and the QGis 1.7
doesn't work either (I was using Qgis 1.6 version when it first occurred, then
I've installed the greater version but it didn't change a thing). <br>
<br>
</span><span lang=ES>Thanks in advance</span></font><font size=2 face=Arial><span
lang=ES style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=ES style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>----------------------------------------------------------------------<o:p></o:p></span></font></p>
<p class=MsoNormal><st1:PersonName ProductID="Dominique Le Cocq" w:st="on"><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Dominique Le
Cocq</span></font></st1:PersonName><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><br>
<b><font color=red><span style='color:red;font-weight:bold'>SiiG</span></font></b>
(<b><font color=red><span style='color:red;font-weight:bold'>S</span></font></b>yndicat
<b><font color=red><span style='color:red;font-weight:bold'>I</span></font></b>ntercommunal
d’<b><font color=red><span style='color:red;font-weight:bold'>I</span></font></b>nformation
<b><font color=red><span style='color:red;font-weight:bold'>G</span></font></b>éographique)</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>115 Avenue de la Roquette – ZA de Berret – 30
200 Bagnols-sur-Cèze<o:p></o:p></span></font></p>
<p class=MsoNormal><u><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Tél</span></font></u><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>: 04.66.90.58.00 – <u>Fax</u>:
04.66.82.98.35 – <u>Mail</u>: </span></font><font size=2 color=blue
face=Arial><span lang=ES style='font-size:10.0pt;font-family:Arial;color:blue'><a
href="mailto:dlecocq@siig.fr"><span lang=FR>dlecocq@siig.fr</span></a></span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> – <u>Web</u>:
</span></font><font size=2 color=blue face=Arial><span lang=ES
style='font-size:10.0pt;font-family:Arial;color:blue'><a
href="http://www.siig.fr" title="blocked::http://www.siig.fr/"><span lang=FR><span
title="blocked::http://www.siig.fr/">http://www.siig.fr</span></span></a></span></font><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=ES style='font-size:10.0pt;
font-family:Arial'><img border=0 width=55 height=64 id="_x0000_i1033"
src="cid:image001.gif@01CC79D3.ED536E30"></span></font><font size=2 face=Arial><span
lang=ES style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=ES
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>