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

Standaert Arnout arnout.standaert at vito.be
Tue Nov 23 07:31:28 PST 2010


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.





More information about the Qgis-user mailing list