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

[John Callahan]

You can have more then one version of QGIS installed. I've had three
versions installed at the same time.

You should be able to simply uninstall what's there, and delete the install
folder.

- John



On Mon, Jul 18, 2011 at 8:47 PM, Vishal Mehta <vishal.mehta at sei-us.org>wrote:

> 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>
> 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/9726c35d/attachment.html>