[mapserver-users] Mapserver / PostGIS Connection troubles

[Nicolas Boretos]

Hi,

I am having a problem connecting to postgis/mapserver at demo_init stage..

The data_dir is read-write, the rest of postgres is read-only

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 
cty_name::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text 
from ctybdpy2 WHERE the_geom && setSRID('BOX3D(388107.634400379 
5200301.16644403,500896.339019834 5313063.02375446)'::BOX3D, 
find_srid('','ctybdpy2','the_geom') )

would appreciate some insight,

regards,
nicolas boretos