Paul, I had the same issue. The functions have been renamed in PostGIS 2. You need to run legacy_minimal.sql in PostGreSQL. That file can be found here: \PostgreSQL\9.1\share\contrib\postgis-2.0. Regards, Donald
-----Original Message----- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Paul Maddock Sent: 26 April 2012 21:52 To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Postgis/mapserver error Dear all, I'm currently trying to have mapserver v6.0.1 grab data from my postgis database v 2.0.0 . When I request the layer through mapserver using cgi commands I get the following error message: msDrawMap(): Image handling error. Failed to draw layer named 'aep_polygon_polyline'. msPostGISLayerWhichShapes(): Query error. Error (ERROR: function geomfromtext(unknown, integer) does not exist LINE 1: ...gid" from aep_polygon_polyline where geom_3754 && GeomFromTe... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ) executing query: select encode(ST_AsBinary(ST_Force_2D("geom_3754"),'NDR'),'hex') as geom,"gid" from aep_polygon_polyline where geom_3754 && GeomFromText('POLYGON((980934.251404232 125495.986,980934.251404232 1038792.604,2809561.55559577 1038792.604,2809561.55559577 125495.986,980934.251404232 125495.986))',3754) my mapfile looks like this: LAYER NAME "aep_polygon_polyline" STATUS ON TYPE line CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=aep_columbus user=****** password=******** port=5432" DATA "geom_3754 from aep_polygon_polyline using unique gid using srid=3754" PROJECTION "init=epsg:3754" END CLASSITEM 'gid' CLASS STYLE COLOR 200 200 200 OUTLINECOLOR 200 200 200 SIZE 2 END END END I used the following command to create my shapefile: shp2pgsql -s 3754 -g geom_3754 /path/to/my/shpfile | psql -h localhost -U postgres -p 5432 -d aep_columbus 3754 is Ohio State Plane South. Does this mean that I need to use the -G geography option to make my data properly render? Thank you so much, Paul Paul A. Maddock Mapping Technician IJUS LLC 560 Officenter Place Gahanna, OH 43230 Cell: (513) 404-6476 <http://www.ijus.net/index.html> Description: Description: Home
<<image001.gif>>
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users