[postgis-users] Re: postgis and mapserver problem

[Gino Lucrezi]

> > Thanks for the help Jan. I found out what the problem was. It seems in the
> > DATA statement of the map file the "FROM" keyword needs to be in lower case.
> > i.e. "shape from table" not "shape FROM table"
> > 
> > A bug has been raised for this on the map server site.

It is:
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=623

I raised it :-)

Unfortunately, mapserver's bugzilla doesn't allow voting on issues, otherwise I'd recommend that Postgis users vote for it.

> This shouldnt be the case unless you're using a mappostgis.c thats more 
> than a years old.

-rw-r--r-- 45701 14 ott  2003 /usr/local/src/mapserver-4.0.1/mappostgis.c

My one is dated 14 oct 2003, so the bug is more recent.

It's from MapServer 4.0.1, which at the time was the most recent stable release (a few weeks ago they released 4.0.2, but we haven't installed it yet).

The bug is still marked as new in Bugzilla, but I see that the headers for mappostgis.c in 4.0.2 now include:

#include <ctype.h> /* tolower() */

so I hope it's been fixed :-)

Gino