postgis tests on Debian Etch (5 errors 1 failure left)

[Bernhard Reiter]

Got around to look at
[#173] postgis testcase not usable with recent debian systems

Since Revision 2714 if you set the direct path to pg_ctl in 
test/postgissupport.py you can run the tests. 
(#173 still needs some work.)

Now I get 5 Errors and one failure:
======================================================================
ERROR: 
test_postgis_db.TestPostGISShapestorePointOIDAsGIDColumn.test_all_shapes
----------------------------------------------------------------------
Traceback (most recent call last):
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 760, in test_all_shapes
    self.assertEquals(len(list(self.store.AllShapes())), 34)
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/Thuban/Model/postgisdb.py", 
line 670, in AllShapes
    cursor.execute("SELECT %s, AsText(%s) FROM %s ORDER BY %s"
ProgrammingError: ERROR:  column "oid" does not exist

SELECT "oid", AsText("the_geom") FROM "landmarks_point_id" ORDER BY "oid"

======================================================================
ERROR: 
test_postgis_db.TestPostGISShapestorePointOIDAsGIDColumn.test_shape_points
----------------------------------------------------------------------
Traceback (most recent call last):
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 743, in test_shape_points
    gid = self.find_test_shape_id()
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 730, in find_test_shape_id
    return list(shapes)[0].ShapeID()
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/Thuban/Model/postgisdb.py", 
line 688, in ShapesInRegion
    cursor.execute("SELECT %(gid)s, AsText(%(geom)s) FROM %(table)s"
ProgrammingError: ERROR:  column "oid" does not exist

SELECT "oid", AsText("the_geom") FROM "landmarks_point_id" WHERE "the_geom" && 
GeometryFromText('POLYGON((-20.000000 64.000000, -20.000000 67.000000, 
-24.000000 67.000000, -24.000000 64.000000, -20.000000 64.000000))', 1) ORDER 
BY "oid"

======================================================================
ERROR: 
test_postgis_db.TestPostGISShapestorePointOIDAsGIDColumn.test_shape_raw_data
----------------------------------------------------------------------
Traceback (most recent call last):
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 749, in test_shape_raw_data
    gid = self.find_test_shape_id()
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 730, in find_test_shape_id
    return list(shapes)[0].ShapeID()
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/Thuban/Model/postgisdb.py", 
line 688, in ShapesInRegion
    cursor.execute("SELECT %(gid)s, AsText(%(geom)s) FROM %(table)s"
ProgrammingError: ERROR:  column "oid" does not exist

SELECT "oid", AsText("the_geom") FROM "landmarks_point_id" WHERE "the_geom" && 
GeometryFromText('POLYGON((-20.000000 64.000000, -20.000000 67.000000, 
-24.000000 67.000000, -24.000000 64.000000, -20.000000 64.000000))', 1) ORDER 
BY "oid"

======================================================================
ERROR: 
test_postgis_db.TestPostGISShapestorePointOIDAsGIDColumn.test_shape_shapeid
----------------------------------------------------------------------
Traceback (most recent call last):
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 738, in test_shape_shapeid
    gid = self.find_test_shape_id()
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 730, in find_test_shape_id
    return list(shapes)[0].ShapeID()
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/Thuban/Model/postgisdb.py", 
line 688, in ShapesInRegion
    cursor.execute("SELECT %(gid)s, AsText(%(geom)s) FROM %(table)s"
ProgrammingError: ERROR:  column "oid" does not exist

SELECT "oid", AsText("the_geom") FROM "landmarks_point_id" WHERE "the_geom" && 
GeometryFromText('POLYGON((-20.000000 64.000000, -20.000000 67.000000, 
-24.000000 67.000000, -24.000000 64.000000, -20.000000 64.000000))', 1) ORDER 
BY "oid"

======================================================================
ERROR: 
test_postgis_db.TestPostGISShapestorePointOIDAsGIDColumn.test_shapes_in_region
----------------------------------------------------------------------
Traceback (most recent call last):
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 756, in test_shapes_in_region
    self.assertEquals(len(list(shapes)), 7)
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/Thuban/Model/postgisdb.py", 
line 688, in ShapesInRegion
    cursor.execute("SELECT %(gid)s, AsText(%(geom)s) FROM %(table)s"
ProgrammingError: ERROR:  column "oid" does not exist

SELECT "oid", AsText("the_geom") FROM "landmarks_point_id" WHERE "the_geom" && 
GeometryFromText('POLYGON((-20.000000 64.000000, -20.000000 67.000000, 
-24.000000 67.000000, -24.000000 64.000000, -20.000000 64.000000))', 1) ORDER 
BY "oid"

======================================================================
FAIL: 
test_postgis_db.TestPostGISConnection.test_gis_tables_with_views_and_tables
----------------------------------------------------------------------
Traceback (most recent call last):
  File 
"/mobilehome/bernhard/hacking/thuban/root/trunk/thuban-on-sid/test/test_postgis_db.py", 
line 127, in test_gis_tables_with_views_and_tables
    [("oid", FIELDTYPE_INT), ("a", FIELDTYPE_INT),
AssertionError: [('a', 'int'), ('the_geom', 'geometry')] != [('oid', 'int'), 
('a', 'int'), ('the_geom', 'geometry')]

======================================================================
FAIL: Extensions.ogr.test.test_OGRShapestore.TestOGRTable.test_Column
======================================================================
FAIL: Extensions.ogr.test.test_OGRShapestore.TestOGRTable.test_Columns
----------------------------------------------------------------------
Ran 578 tests in 144.505s

FAILED (failures=3, errors=5)
skipped = 0


-- 
Managing Director - Owner, www.intevation.net       (Free Software Company)
Germany Coordinator, fsfeurope.org       (Non-Profit Org for Free Software)
www.kolab-konsortium.com   (Email/Groupware Solution, Professional Service)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://www.intevation.de/pipermail/thuban-devel/attachments/20061106/898cbb94/attachment.bin