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
