[Mapserver-users] Mapserver + PostGIS for dummies.

[Jason M. Nielsen]

Quoting Eric Bridger <eric at gomoos.org>:

> Just started using postgis recently and the error messages are a bit
> cryptic.  Just yesterday I spent an hour staring at a simliar error (you
> can try running the query i.e. everything after BINARY CURSOR FOR from
> psql to see if it works).  Until I checked the postgres log and realized
> that the table created by shp2pgsql had not granted permissions for my
> web user.  GRANT SELECT ON .... TO PUBLIC fixed the problem.
> 
> The using clauses are for advance queries with a sub-select. You are
> probably using the (1) the_geom from [table_name] form of query.
> 
> Note: there is a postgis list at:
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Didnt think about that. Good information. I checked and there were no users
granted privledges to the table so I first added the intended user and
ultimately public but still no luck. Same error came back.

Thanks, Jason.

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/