Hi,
See http://trac.osgeo.org/mapserver/ticket/4186
and try legacy.sql as first aid.
-Jukka Rahkonen-
abhishek bansal wrote:
> Hello All,
> I am trying to display a simple shape file from postgis database but error
> log keep giving me this.
[Sat May 12 15:47:53 2012].968000 CGI Request 1 on process 4748
[Sat May 12 15:47:53 2012].968000 msDrawMap(): WMS/WFS set-up and query, 0.000s
[Sat May 12 15:47:53 2012].995000 msPostGISLayerWhichShapes(): Query error.
Error (ERROR: function force_2d(geometry) does not exist
LINE 1: select encode(AsBinary(force_collection(force_2d("geom")),'N...
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
) executing query: select
encode(AsBinary(force_collection(force_2d("geom")),'NDR'),'hex') as geom,"gid"
from waterways where geom && GeomFromText('POLYGON((64.7695553856427
8.082365,64.7695553856427 34.585531,100.121858614357 34.585531,100.121858614357
8.082365,64.7695553856427 8.082365))',4326)
[Sat May 12 15:47:53 2012].996000 msDrawMap(): Image handling error. Failed to
draw layer named 'waterways'.
[Sat May 12 15:47:53 2012].996000 msFreeMap(): freeing map at 01E5C1F8.
my postgres version is 9.0, gdal 1.8, i am using MS4W on windows 7
This shape file was working perfectly on PostGIS 1.5 but now its not working on
version 2.
please help !!
--
Thanks & Regards,
Abhishek Bansal
http://abhishekbansal.miyuri.com
Jaypee Institute of Information Technology, Noida
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
