[Qgis-user] Error inserting a shapefile in qgis "Add PostGIS layer

legio nostra legio.patria at gmail.com
Fri Oct 15 06:30:53 PDT 2010


Hello everyone,

I am trying to insert a shapefile using the icon "Add PostGIS layer", and
when I choose the layer that I want, it opens perfectly without giving any
error.

If then I save the project Qgis and exit, and then try to open the same
project, this error message appears:



2 cursor states lost.

SQL: declare qgisf13 binary cursor for select
"gid",asbinary("the_geom",'NDR'),"OBJECTID_1"::text,"Dicofre"::text,"Freguesia"::text,"Municipio"::text,"Distrito_"::text,"Area_EA_Ha"::text,"Area_T_Ha"::text,"TAA"::text,"AREA"::text,"PERIMETER"::text,"OBJECTID"::text,"FREGS01_"::text,"FREGS01_ID"::text,"FRNUM01"::text,"AREA_ha"::text,"Shape_area"::text,"Shape_len"::text
from "LIMITES_ADMINISTRATIVOS"."LA_FREGUESIAS_PG"

Result: 7 (ERROR: DECLARE CURSOR can only be used in transaction blocks

)


I close the window, and then opens another with another error message:



1 cursor states lost.

SQL: CLOSE qgisf12

Result: 7 (ERROR: cursor "qgisf12" does not exist

)


This file comes from CAOP 2010 (Portugal), when it was introduced in DB
"pgAdmin III" did not give any error.

Does anyone know what this error might be, and how can I fix it?

Thanks for the help.


Orlando
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20101015/36bfd6f2/attachment.html>


More information about the Qgis-user mailing list