[mapserver-users] postgis problem

[Vinko Vrsalovic]

On Sat, Nov 30, 2002 at 01:00:14PM -0500, Kevin Webb wrote:
> Hi,
> 
> I am running into some strange problems with PostGIS connectivity in
> Mapserver 3.6.3.
 
> msPOSTGISLayerWhichShapes(): Query error. prep_DB:Error executing POSTGIS
> DECLARE statement (0.6 failed - retried 0.5 and it failed too). DECLARE
> mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d()),'NDR'),OID::text from WHERE &&
> setSRID('BOX3D(310076.012720145 5100431.37679792,638159.168888574
> 5428514.53296635)'::BOX3D, find_srid('','','') )

I recommend you recompile mapserver with the latest mappostgis.c from
CVS, it has a (whole lot) better error reporting. It shows the response
from postgres, among other things...

This line: 
> DATA "the_geom FROM lakespy2"

should be:
> DATA "the_geom from lakespy2"


-- 
Vinko Vrsalovic <el[|- at -|]vinko.cl>
http://www.cprsig.cl