<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<meta name="qrichtext" content="1">
<p style="margin: 0px; text-indent: 0px;">Hi all.</p>
<p style="margin: 0px; text-indent: 0px;">I'm consistently getting
an error trying to visualize the table of a specific geometry in
DB Manager.<br>
Any suggestion?<br>
Thanks.<br>
===<br>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
Traceback (most recent call last):<br>
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/data_model.py",
line 60, in data<br>
val = self.getData(index.row(), index.column())<br>
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/data_model.py",
line 116, in getData<br>
self.fetchMoreData(start)<br>
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/data_model.py",
line 76, in fetchMoreData<br>
return self.fetchMoreData(row_start)<br>
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/data_model.py",
line 70, in fetchMoreData<br>
self._createCursor()<br>
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/data_model.py",
line 49, in _createCursor<br>
self.db._execute(self.cursor, sql)<br>
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/connector.py",
line 84, in _execute<br>
raise DbError(e, sql)<br>
DbError: Error:<br>
current transaction is aborted, commands ignored until end of
transaction block<br>
<br>
<br>
Query:<br>
SELECT "id"::text, "provincia"::text, CASE WHEN "st_intersection"
IS NULL THEN NULL ELSE GeometryType("st_intersection") END AS
"st_intersection", "area_km2"::text,
"percentuale_incendiata"::text FROM "public"."province_incendiate"<!--EndFragment--></p>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-15">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<pre class="moz-signature" cols="72">--
Paolo Cavallini - Faunalia
<a class="moz-txt-link-abbreviated" href="http://www.faunalia.eu">www.faunalia.eu</a>
Full contact details at <a class="moz-txt-link-abbreviated" href="http://www.faunalia.eu/pc">www.faunalia.eu/pc</a>
Nuovi corsi QGIS e PostGIS: <a class="moz-txt-link-freetext" href="http://www.faunalia.it/calendario">http://www.faunalia.it/calendario</a></pre>
</body>
</html>