<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi everyone.<br>i've used workshop material of FOSS4G2007 to learn postgis along with its data. but there is a problem<br>i got this error in first attempt to retrieve data from postgis:<br><br>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)) <br><br>i don't know what causes the problem although it sounds easy.<br>THX<br></div></div><br>
</body></html>