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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users