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

[Antti.Roppola at brs.gov.au]

Hello all,

I generated a point layer and that works OK. Since the
release notes for PostGIS 0.7.2 and 0.7.3 mention fixes
to shp2pgsql, I am guessing that may have something to do
with it.

Thanks,

Antti

-----Original Message-----
From: Roppola, Antti - BRS 
Sent: Thursday, 5 September 2002 2:37 PM
To: mapserver-users at lists.gis.umn.edu
Subject: Querying PostGIS layer attributes -> error


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