[postgis-users] Update to where clause errors

[Paul A Peters]

Thanks, it was indeed just case sensitivity. I changed the definition to
"the_geom from gis_test USING SRID=-1" and it worked fine. I am not building
postgis myself but am rather using a built install provided by Tyler
Mitchell a few days ago. Thus, I can't do much with the new .c file right
now. We may get into building mapserver, etc... later on. For right now
we're trying to get this project working. Mike Leahy (also posting here) and
I have been racing to see who's build can get working first. It appears as
if I get the prize. Thanks. I'll probably post with more problems the
farther we get into this. 

Thanks,
Paul

Paul A Peters
http://www.fes.uwaterloo.ca/u/papeters


-----Original Message-----
From: David Blasby [mailto:dblasby at refractions.net] 
Sent: May 27, 2003 3:35 PM
To: papeters at alumni.uwaterloo.ca; postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Update to where clause errors


Paul A Peters wrote:
> David:
> 
> I was indeed using the wrong point type, thanks for the help. I have 
> gone back and rebuilt my postgis installation and rebuilt my test 
> database. However, I am still getting the same error as before. So, I 
> tried the "\d gis_test" as suggested and I got the response attached. 
> Thus, I am still lost.

I think you need a more recent version of mappostgis.c.  I believe the 
one you are using is case sensitive - try changing "FROM" to "from" in 
your mapfile's DATA statement.

I've attached the most recent mappostgis.c for you to upgrade to.

If this doesnt give you an error but you get a blank map, you probably 
didnt use AddGeometryColumn() to put the geometry column in gis_test. 
To fix it either add the appropriate row to the geometry_columns table 
or use this data statement:

the_geom from gis_test USING SRID=-1


dave