[bug #3068] (thuban) connetion with postgis database

[Request Tracker]

this bug's URL: http://intevation.de/rt/webrt?serial_num=3068
-------------------------------------------------------------------------

Subject: connetion with postgis database

Operating System: GNU/Linux, conectiva 10
Thuban version: 1.0.1, Thuban-1.0.1.tar.gz
wxPython version: 2.4.2.4, conecitva rpm 
Python version: other, 2.3.3 conectiva rpm 
PySQLite version: 0.5.0, conecitva rpm
SQLite version: other, 2.8.13  conectiva rpm
GDAL version: 1.2.5, compiled
proj version: other, 4.4.9  compiles

Please enter error description here.
Did you compile Thuban yourself?
yes
----------
trying to edit properties:

ERROR:  current transaction is aborted, commands ignored until end of transaction block

SELECT f_table_name FROM geometry_columns;

Traceback (most recent call last):
  File "/usr/local//lib/thuban/Thuban/UI/dbdialog.py", line 100, in OnRetrieve
    self.tables = self.selected_conn.GeometryTables()
  File "/usr/local//lib/thuban/Thuban/Model/postgisdb.py", line 139, in GeometryTables
    cursor.execute("SELECT f_table_name FROM geometry_columns;")
ProgrammingError: ERROR:  current transaction is aborted, commands ignored until end of transaction block

SELECT f_table_name FROM geometry_columns;
-----------
trying to ope table:


Uma exceção não prevista ocorreu:
ERROR:  current transaction is aborted, commands ignored until end of transaction block

SELECT count(*) FROM "geosetores"

Traceback (most recent call last):
  File "/usr/local//lib/thuban/Thuban/UI/legend.py", line 215, in _OnShowTable
    self.mainWindow.LayerShowTable()
  File "/usr/local//lib/thuban/Thuban/UI/mainwindow.py", line 639, in LayerShowTable
    layer, table)
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 579, in __init__
    QueryTableFrame.__init__(self, parent, name, title, table)
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 365, in __init__
    TableFrame.__init__(self, parent, name, title, table)
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 312, in __init__
    self.grid = self.make_grid(self.table)
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 608, in make_grid
    return LayerTableGrid(self, table)
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 165, in __init__
    self.table = DataTable(table)
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 44, in __init__
    self.SetTable(table)
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 49, in SetTable
    self.num_rows = table.NumRows()
  File "/usr/local//lib/thuban/Thuban/Model/postgisdb.py", line 269, in NumRows
    cursor.execute("SELECT count(*) FROM %s" % self.quoted_tablename)
ProgrammingError: ERROR:  current transaction is aborted, commands ignored until end of transaction block

SELECT count(*) FROM "geosetores"

-------------
closing thuban returns:

LayerTableFrame instance has no attribute 'map'

Traceback (most recent call last):
  File "/usr/local//lib/thuban/Thuban/UI/tableview.py", line 602, in OnDestroy
    self.map.Unsubscribe(MAP_LAYERS_REMOVED, self.map_layers_removed)
AttributeError: LayerTableFrame instance has no attribute 'map'





-------------------------------------------- Managed by Request Tracker