Open tbonfort opened 12 years ago
Author: fwarmerdam Date: 2005/10/28 - 16:15
Adding Jerry to the cc list.
Author: tomkralidis Date: 2008/01/24 - 17:12 Is this still a valid issue?
Author: warmerdam Date: 2008/01/24 - 17:44 I have setup a roughly corresponding setup again and run it and things seem to work using the latest FWTools build of mapserver/shp2img from trunk (well a couple weeks old). So I think we can close this report. Debug output looks like this:
warmerda@gdal64[103]% shp2img -m ukpoly2.map -o out.png -all_debug 1
msPOSTGISLayerOpen called datastatement: wkb_geometry from polygon
MSPOSTGISLayerOpen -- shared connection not available.
msConnPoolRegister(ukpoly,dbname=warmerda host=gdal,0x80d03c8)
msPOSTGISLayerFreeItemInfo called
msPOSTGISLayerWhichShapes called
msPOSTGISLayerRetrievePGVersion(): query = select substring(version() from 12 for (position('on' in version()) - 13))
msPOSTGISLayerRetrievePGVersion: Version String: 8.1.5
msPOSTGISLayerRetrievePGVersion(): Found version 8, 1, 5
msPOSTGISLayerRetrievePK: query = select attname from pg_attribute, pg_constraint, pg_class where pg_constraint.conrelid = pg_class.oid and pg_class.oid = pg_attribute.attrelid and pg_constraint.contype = 'p' and pg_constraint.conkey[1] = pg_attribute.attnum and pg_class.relname = 'polygon' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null
msPOSTGISLayerParseData: unique column = ogc_fid, srid='', geom_column_name = wkb_geometry, table_name=polygon
query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),ogc_fid::text from polygon WHERE wkb_geometry && setSRID('BOX3D(470824.993311037 4751545,489594.006688963 4765610)'::BOX3D, find_srid('','polygon','wkb_geometry') )
msPOSTGISLayerFreeItemInfo called
msPOSTGISLayerClose datastatement: wkb_geometry from polygon
msPOSTGISLayerClose -- closing query_result
msConnPoolRelease(ukpoly,dbname=warmerda host=gdal,0x80d03c8)
msPOSTGISLayerOpen called datastatement: wkb_geometry from polygon
msConnPoolRequest(uklines,dbname=warmerda host=gdal) -> got 0x80d03c8
msPOSTGISLayerFreeItemInfo called
msPOSTGISLayerWhichShapes called
msPOSTGISLayerRetrievePGVersion(): query = select substring(version() from 12 for (position('on' in version()) - 13))
msPOSTGISLayerRetrievePGVersion: Version String: 8.1.5
msPOSTGISLayerRetrievePGVersion(): Found version 8, 1, 5
msPOSTGISLayerRetrievePK: query = select attname from pg_attribute, pg_constraint, pg_class where pg_constraint.conrelid = pg_class.oid and pg_class.oid = pg_attribute.attrelid and pg_constraint.contype = 'p' and pg_constraint.conkey[1] = pg_attribute.attnum and pg_class.relname = 'polygon' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null
msPOSTGISLayerParseData: unique column = ogc_fid, srid='', geom_column_name = wkb_geometry, table_name=polygon
WARNING: there is already a transaction in progress
query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),ogc_fid::text from polygon WHERE wkb_geometry && setSRID('BOX3D(470824.993311037 4751545,489594.006688963 4765610)'::BOX3D, find_srid('','polygon','wkb_geometry') )
msPOSTGISLayerFreeItemInfo called
msPOSTGISLayerClose datastatement: wkb_geometry from polygon
msPOSTGISLayerClose -- closing query_result
msConnPoolRelease(uklines,dbname=warmerda host=gdal,0x80d03c8)
msPOSTGISLayerClose datastatement: wkb_geometry from polygon
msPOSTGISLayerClose -- layerinfo is NULL
msPOSTGISLayerClose datastatement: wkb_geometry from polygon
msPOSTGISLayerClose -- layerinfo is NULL
msConnPoolClose(dbname=warmerda host=gdal,0x80d03c8)
GDAL: GDALDeregister_GTiff() called.
Reporter: warmerdam Date: 2005/10/28 - 16:14