That worked indeed....like a magic !!<br>Thank you Very Much<br><br><div class="gmail_quote">On Sat, May 12, 2012 at 4:00 PM, Rahkonen Jukka <span dir="ltr"><<a href="mailto:Jukka.Rahkonen@mmmtike.fi" target="_blank">Jukka.Rahkonen@mmmtike.fi</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
See <a href="http://trac.osgeo.org/mapserver/ticket/4186" target="_blank">http://trac.osgeo.org/mapserver/ticket/4186</a><br>
and try legacy.sql as first aid.<br>
<span class="HOEnZb"><font color="#888888"><br>
-Jukka Rahkonen-<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
abhishek bansal wrote:<br>
<br>
<br>
> Hello All,<br>
<br>
> I am trying to display a simple shape file from postgis database but error log keep giving me this.<br>
<br>
[Sat May 12 15:47:53 <a href="tel:2012%5D.968000" value="+12012968000">2012].968000</a> CGI Request 1 on process 4748<br>
[Sat May 12 15:47:53 <a href="tel:2012%5D.968000" value="+12012968000">2012].968000</a> msDrawMap(): WMS/WFS set-up and query, 0.000s<br>
[Sat May 12 15:47:53 <a href="tel:2012%5D.995000" value="+12012995000">2012].995000</a> msPostGISLayerWhichShapes(): Query error. Error (ERROR: function force_2d(geometry) does not exist<br>
LINE 1: select encode(AsBinary(force_collection(force_2d("geom")),'N...<br>
^<br>
HINT: No function matches the given name and argument types. You might need to add explicit type casts.<br>
) 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)<br>
[Sat May 12 15:47:53 <a href="tel:2012%5D.996000" value="+12012996000">2012].996000</a> msDrawMap(): Image handling error. Failed to draw layer named 'waterways'.<br>
[Sat May 12 15:47:53 <a href="tel:2012%5D.996000" value="+12012996000">2012].996000</a> msFreeMap(): freeing map at 01E5C1F8.<br>
<br>
my postgres version is 9.0, gdal 1.8, i am using MS4W on windows 7<br>
<br>
This shape file was working perfectly on PostGIS 1.5 but now its not working on version 2.<br>
please help !!<br>
--<br>
Thanks & Regards,<br>
Abhishek Bansal<br>
<a href="http://abhishekbansal.miyuri.com" target="_blank">http://abhishekbansal.miyuri.com</a><br>
Jaypee Institute of Information Technology, Noida<br>
<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Thanks & Regards,<br>Abhishek Bansal<br><a href="http://abhishekbansal.miyuri.com" target="_blank">http://abhishekbansal.miyuri.com</a><br>Jaypee Institute of Information Technology, Noida<br>
<br><br>