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

[John Callahan]

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 <vishal.mehta at sei-us.org>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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110718/ed909a9e/attachment.html>