I found out that this problem was caused by an inconsistency in my PostGIS database. SRID's in the geometry columns were not matching the SRID's listed in the geometry_columns table.
My apologies for the noise! Kind regards, Arnout Standaert -----Original Message----- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Standaert Arnout Sent: dinsdag 23 november 2010 16:31 To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Postgres 9 and PostGIS layers - 1 cursor states lost Hello, I'm running QGis 1.7.0-Trunk (rev 14747) on Windows XP, from the OSGeo4W distribution. When I try to load a PostGIS layer from a PostgreSQL 9 database (PostGIS 1.5), the loading fails and QGis shows this error message: 1 cursor states lost. SQL: CLOSE qgisf6 Result: 7 (ERROR: current transaction is aborted, commands ignored until end of transaction block ) I happen to have the same database in a PostgreSQL 8.3 + PostGIS 1.4 setup, and the layers do load without problems from there. I haven't seen too much references online for this kind of error. Bug #3089 seems to be related, and it has apparently been mentioned on IRC already, however without any clues for a solution. Can anyone shed some more light on this? Kind regards, Arnout Standaert PS. My apologies for the company disclaimer that will probably appear below this post. --- This e-mail, any attachments and the information it contains are confidential and meant only for the use of the addressee(s) only. Access to this e-mail by anyone other than the addressee(s) is unauthorized. If you are not the intended addressee (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message and notify the sender immediately. If you have received this e-mail in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. All reasonable precautions have been taken to ensure no viruses are present in this e-mail and its attachments. As our company cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user --- This e-mail, any attachments and the information it contains are confidential and meant only for the use of the addressee(s) only. Access to this e-mail by anyone other than the addressee(s) is unauthorized. If you are not the intended addressee (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message and notify the sender immediately. If you have received this e-mail in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. All reasonable precautions have been taken to ensure no viruses are present in this e-mail and its attachments. As our company cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
