Hi Thanks for your answer. We were using PostGis 1.5.2 before upgrading, and it used to work properly with QGis. The problem is that there is no setsrid function calling for a (BOX3D, integer) in postgis 1.5.3 (nor in postgis 1.5.2), but it is what QGis is asking each time we're trying to load postgis layer to QGis.
In fact, it seems that in postgis 1.5.3 the BoX3D element doesn't derive from the geometry type. DLC ---------------------------------------------------------------------- Dominique LE COCQ Technicienne SIG SiiG (Syndicat Intercommunal dInformation Géographique) 115 Avenue de la Roquette ZA de Berret 30 200 Bagnols-sur-Cèze Tél: 04.66.90.58.00 Fax: 04.66.82.98.35 Mail: [email protected] Web: http://www.siig.fr -----Message d'origine----- De : [email protected] [mailto:[email protected]] De la part de Sandro Santilli Envoyé : vendredi 23 septembre 2011 14:26 À : PostGIS Users Discussion Cc : [email protected] Objet : Re: [postgis-users] Trouble adding Postgis 1.5.3 layer to QGis On Fri, Sep 23, 2011 at 09:34:01AM +0200, [email protected] wrote: > Hi every one > > I'm using PostGis 1.5.3 and QGis 1.7 and I've troubles adding postgis layers > to QGis. > > 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: > ---------- > > select "oid",asbinary("geom",'NDR') from "cadastre"."commune" where "geom" > && setsrid('BOX3D(794270.8532559783197939 6312919.8975825672969222, > 860762.6940280217677355 6362904.3300199424847960)'::box3d,2154); > ------------ > 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. > ---------- > select "oid",asbinary("geom",'NDR') from "cadastre"."commune" where "geom" > && setsrid(geometry('BOX3D(794270.8532559783197939 6312919.8975825672969222, > 860762.6940280217677355 6362904.3300199424847960)'::box3d),2154); > ---------- > > 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). What version of postgis were you running when it used to work ? You may try dropping the implicit box3d->geography cast from your database. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
