[Qgis-developer] Error in DB Manager

[Paolo Cavallini]

Hi all.

I'm consistently getting an error trying to visualize the table of a
specific geometry in DB Manager.
Any suggestion?
Thanks.
===


Traceback (most recent call last):
  File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/data_model.py",
line 60, in data
    val = self.getData(index.row(), index.column())
  File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/data_model.py",
line 116, in getData
    self.fetchMoreData(start)
  File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/data_model.py",
line 76, in fetchMoreData
    return self.fetchMoreData(row_start)
  File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/data_model.py",
line 70, in fetchMoreData
    self._createCursor()
  File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/data_model.py",
line 49, in _createCursor
    self.db._execute(self.cursor, sql)
  File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/connector.py",
line 84, in _execute
    raise DbError(e, sql)
DbError: Error:
current transaction is aborted, commands ignored until end of
transaction block


Query:
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"

-- 
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20130131/c7e9f11e/attachment.html>