I do not believe PG 2.0 is supported in QGIS 1.6. I had a similar error when I had tried. It does work well using QGIS 1.7 or greater.
- John On Mon, Jul 18, 2011 at 7:45 PM, Vishal Mehta <[email protected]>wrote: > Hi all,**** > > ** ** > > I’m using Quantum GIS 1.6.0, **** > > Postgresql 9.0 and **** > > Postgis 2.0 (dev version)** > > ** ** > > On Windows 7.**** > > ** ** > > I’m having trouble adding a Postgis layer to QGIS. I loaded a shapefile > into my database separately using the shapefile loader and that seemed to > woork fine. However when I try to bring it into QGIS I get the following > error:**** > > *1 cursor states lost.* > > *SQL: declare qgisf1 binary cursor for select "gid",asbinary("geom",'NDR') > from "public"."wardscleanattributes" where "geom" && > setsrid('BOX3D(-1.2547169811320755 -1.0000000000000000, 1.2547169811320755 > 1.0000000000000000)'::box3d,-1)* > > *Result: 7 (ERROR: function asbinary(geometry, unknown) does not exist* > > *LINE 1: declare qgisf1 binary cursor for select "gid",asbinary("geom...* > > *^* > > *HINT: No function matches the given name and argument types. You might > need to add explicit type casts.* > > *)* > > ** ** > > The layer has a gist index, as well as a serial, primary key column.**** > > The same procedure used to work fine with**** > > QGIS 1.0.2 – postgresql 8.3 and postgis 1.5**** > > ** ** > > Help?**** > > Vishal**** > > ** ** > > ** ** > > ** ** > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
