[Mapserver-users] msPOSTGISLayerWhichShapes() error

David Blasby dblasby at refractions.net
Wed Jul 16 12:53:17 EDT 2003


> SELECT  
> ship_name::text,asbinary(force_collection(force_2d(the_ln_geom)),'NDR'), 
> OID::text from ship_voy using UNIQUE oid WHERE (voyage_id > 0) and  
> (the_ln_geom && setSRID( 'BOX3D(-180 -90,180 90)'::BOX3D,4008) )  in  
> /home/virtual/site170/fst/var/www/html/mapping.gis on line 728


>     DATA "the_ln_geom from ship_voy USING UNIQUE oid USING SRID=4008"

This does look like you're using a very old version of mappostgis.c - 
this problem should be fixed in the 3.6.6 CVS version.

Try just using

DATA "the_ln_geom from ship_voy"

make sure you have an entry in the geometry_columns table.

dave




More information about the mapserver-users mailing list