[postgis-users] Postgis layer in mapserver

[Jan Hartmann]

It's hard to believe, but

------> using SRID = <srid>

works, but

------> USING SRID = <srid>

or

------> using srid = <srid>

don't, not even in MapServer 3.7!

Dave, couldn't you fix up something for this? I never had this problem, 
but that was just pure luck.

Jan


Oscar Testa wrote:
> Ok, but my data express the next:
> 
>   DATA "the_geom from (select locarg.oid as oid, locarg.the_geom as
> the_geom, localidad.nombre as nombre from locarg, localidad where
> locarg.codpostal = localidad.codigopostal) AS prueba USING SRID=4326 
> USING
> UNIQUE oid"
> 
> and the error is the next:
> 
> MapServer Error in msPOSTGISLayerWhichShapes(): prep_DB:Error executing
> POSTGIS DECLARE statement (0.6 failed - retried 0.5 and it failed too).
> DECLARE mycursor BINARY CURSOR FOR SELECT
> Provincia::text,asbinary(force_collection(force_2d
> (the_geom)),'NDR'),OID::te
> xt from (select locarg.oid as oid, locarg.the_geom as the_geom,
> localidad.nombre as nombre from locarg, localidad where 
> locarg.codpostal =
> localidad.codigopostal) AS prueba USING SRID=-1 USING UNIQUE oid WHERE
> the_geom &&
> setSRID('BOX3D(-78.22636066 -55.575152,-48.54710934 -20.90357)'::BOX3D,
> find_srid('','locarg,','the_geom') )
> 
> ??????
> 
> About classes in mapserver, i have no problem.  My problem at this 
> moment is
> the join....
> 
> Thanks
> Oscar


Jan Hartmann
Department of Geography
University of Amsterdam
jhart at frw.uva.nl