[Qgis-user] trouble adding postgis(2.0) layer to qgis(1.6)

[Vishal Mehta]

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110718/91bf2600/attachment.html>