[postgis-users] Problem displaying postgis data with maapserver

[strk at refractions.net]

Looks like an bug in mappostgis.c ... ask on mapserver lists.
--strk;

On Wed, Mar 09, 2005 at 06:36:21PM +0000, Shaq Gbadebo wrote:
> Hi!
> 
> I have sorted out an initial problem, which was my postgresql server was 
> not not set for tcp/ip connections. But now here is the error I am getting.
> 
> msDrawMap(): Image handling error. Failed to draw layer named 'test'.
> prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query) 
> statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT 
> asbinary(force_collection(force_2d()),'NDR'),OID::text from HBHB WHERE 
> && setSRID('BOX3D(-1333332 -999999,1333332 999999)'::BOX3D, 
> find_srid('','HBHB','') )'
> 
> Postgresql reports the error ''
> 
> More Help:
> 
> Error with POSTGIS data variable. You specified '<check your .map file>'.
> Standard ways of specifiying are :
> (1) 'geometry_column from geometry_table'
> (2) 'geometry_column from (<sub query>) as foo using unique <column name> 
> using SRID=<srid#>'
> 
> Make sure you put in the 'using unique <column name>' and 'using SRID=#' 
> clauses in.
> 
> For more help, please see http://postgis.refractions.net/documentation.php
> 
> Mappostgis.c - version of June 12/2003.
> msPOSTGISLayerParseData(): Query error. Error parsing POSTGIS data 
> variable. Must contain 'geometry_column from table_name' or 'geom from 
> (subselect) as foo' (couldnt find ' from '). More help:
> 
> Error with POSTGIS data variable. You specified 'geom FROM test'.
> Standard ways of specifiying are :
> (1) 'geometry_column from geometry_table'
> (2) 'geometry_column from (<sub query>) as foo using unique <column name> 
> using SRID=<srid#>'
> 
> Make sure you put in the 'using unique <column name>' and 'using SRID=#' 
> clauses in.
> 
> For more help, please see http://postgis.refractions.net/documentation.php
> 
> Mappostgis.c - version of June 12/2003.
> 
> Any sort of help would be appreciated.
> 
> Thanks
> 
> Shaq.
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users