Hi Andreas,
I have similar problems, but with Postgis 1.5.
I posted last week on qgis and postgis users:
http://old.nabble.com/MultiPoint-to-CircularString-to-LineString-td33132890.html
In my case, I noticed thaht when building a geometry, you have to
enforce the SRID in it, with EWKT for example. If you don't want to, you
have to feed a -1 for the SRID in the geometry_columns.
If you do not do this (i.e. have a SRID in geometry_columns and nothing
in the view), there is no error in postgis, but you have a problem in
QGIS. I have experienced the same error:
Query: CLOSE qgisf0 returned 7 [ERROR: current transaction is aborted,
commands ignored until end of transaction block
]
Hope it helps a bit,
Denis
On 01/18/2012 12:07 AM, Andreas Neumann wrote:
Hi,
I recently experimented again with Postgis 2.0 again. I noticed while
loading the Views works fine, that I cannot pick an object with the info
tools.
It works fine with regular tables, but fails for views.
Here is the error message I get in the log:
-----------------------
Fetching from cursor qgisf0 failed
Database error: ERROR: Operation on mixed SRID geometries
Query: CLOSE qgisf0 returned 7 [ERROR: current transaction is aborted,
commands ignored until end of transaction block
]
1 cursor states lost.
SQL: CLOSE qgisf0
Result: 7 (ERROR: current transaction is aborted, commands ignored
until end of transaction block
)
-----------------
The error message about the mixed geometries is strange, since the view
and the project have the same SRID.
Any idea what could be wrong here? Currently I only have a Postgis 2.0
database available, so I can't test with Postgis 1.5 at the same time.
Maybe with a virtual machine ...
Andreas
_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
