[mapserver-users] error accessing PostGIS 2 layer

[Puneet Kishor]

I migrated my data to PostGIS 2, and now I am getting the following error (using the same mapfile as with PostGIS 1.5.3)

	msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  function 
	geomfromtext(unknown, integer) does not exist
	LINE 1: ...e_geom FROM trees.range) a_view where the_geom && GeomFromTe...
                                                             ^
	HINT:  No function matches the given name and argument types. You might need to 
	add explicit type casts.

The offending query in the mapfile is 

	DATA "the_geom FROM (SELECT gid, species_id, species_color, the_geom FROM trees.range) a_view USING UNIQUE gid USING srid=4326"

So, it seems the MapServer is using that line to construct its own query, and that query is not compliant with PostGIS 2. Suggestions?




--
Puneet Kishor