[mapserver-users] newbie: Error in first atttempt to use postgis with mapserver?

[Saka Royban]

Hi everyone.
i've used workshop material of FOSS4G2007 (PostGIS workshop)to learn postgis along with its data. but there is a problem
i got this error in first attempt to retrieve data from postgis:

msDrawMap():
Image handling error. Failed to draw layer named 'bc_municipality'.
prepare_database(): Query error. Error declaring cursor: ERROR: column
"oid" does not exist LINE 1:
...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^
With query string:
DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
bc_municipality WHERE the_geom && setSRID('BOX3D(458426.1
260651.497368421,1943216.4
1373313.90263158)'::BOX3D, find_srid('','bc_municipality ','the_geom')
) msPOSTGISLayerRetrievePGVersion(): Query error. Error executing
POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select
substring(version() from 12 for (position('on' in version()) - 13)) 

i don't know what causes the problem although it sounds easy.
THX




-----Inline Attachment Follows-----

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090115/c935b748/attachment.htm>