<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Andreas,<br>
<br>
I have similar problems, but with Postgis 1.5.<br>
I posted last week on qgis and postgis users:
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<a
href="http://old.nabble.com/MultiPoint-to-CircularString-to-LineString-td33132890.html">http://old.nabble.com/MultiPoint-to-CircularString-to-LineString-td33132890.html</a><br>
<br>
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.<br>
<br>
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:<br>
<br>
<pre wrap="">Query: CLOSE qgisf0 returned 7 [ERROR: current transaction is aborted,
commands ignored until end of transaction block
]</pre>
Hope it helps a bit,<br>
<br>
Denis<br>
<br>
On 01/18/2012 12:07 AM, Andreas Neumann wrote:
<blockquote cite="mid:4F15FF42.4030004@carto.net" type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
</pre>
</blockquote>
</body>
</html>