[Qgis-user] RE: Postgres 9 and PostGIS layers - 1 cursor states lost

[Standaert Arnout]

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-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Standaert Arnout
Sent: dinsdag 23 november 2010 16:31
To: qgis-user at 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 at 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.