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

[Vishal Mehta]

Thanks John,
I can try installing QGIS 1.7 and try loading postgis2.0 layer it again. Do I need to uninstall QGIS1.6 as well as the GRASS installations it came with first?

(I had used the stand alone installer that included GRASS earlier, but don't seem to have an uninstall option for all of them together..unless I am missing something)

Vishal



From: John Callahan [mailto:john.callahan at udel.edu]
Sent: Monday, July 18, 2011 5:22 PM
To: Vishal Mehta
Cc: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] trouble adding postgis(2.0) layer to qgis(1.6)

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<mailto: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<mailto: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/a4d1bb64/attachment.html>