[mapserver-users] Querying PostGIS layer attributes -> error

[Antti.Roppola at brs.gov.au]

Hi all,

I have PostGIS 0.7.1 built into Postgres 7.2.1 and it works
as a data source for generating maps. However, running any
queries against a PostGIS layer gives me an error (see below).

Is this a know issue, or am I doing something wrong? I have the
same data and layer entry as a shape and it works fine.

Cheers,

Antti


Fatal error: MapServer Error in msPOSTGISLayerGetShape(): Error executing POSTGIS SQL statement: DECLARE mycursor BINARY CURSOR FOR SELECT gid::text,fnode_::text,tnode_::text,lpoly_::text,rpoly_::text,length::text,xyc00002_::text,xyc00002_i::text,id::text,f_code::text,f_code_des::text,acc::text,acc_descri::text,exs::text,exs_descri::text,med::text,med_descri::text,rst::text,rst_descri::text,rsu::text,rsu_descri::text,rtt::text,rtt_descri::text,soc::text,tile_id::text,edg_id::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from roads WHERE OID = 35115 in /home/www2/mapserv/sde_demo/functions.inc on line 105