Hi everyone.
i've used workshop material of FOSS4G2007 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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users