[mapserver-users] Force_2d does not exist

[abhishek bansal]

That worked indeed....like a magic !!
Thank you Very Much

On Sat, May 12, 2012 at 4:00 PM, Rahkonen Jukka
<Jukka.Rahkonen at mmmtike.fi>wrote:

> 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
>
>
>


-- 
Thanks & Regards,
Abhishek Bansal
http://abhishekbansal.miyuri.com
Jaypee Institute of Information Technology, Noida
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120512/4ba98733/attachment.html