Graham,
Postgresql normally assumes table and column names will be in lower case
and if not you need to quote them. So try:
DATA ""the_geom from north"
and/or (notice the quoting below)
DATA 'the_geom from "North"'
I think you will find things easier if you keep everything as lower case
schema, table and column names.
-Steve W
On 4/27/2011 3:45 AM, Ben Madin wrote:
Graham,
It looks OK to me. Although the brevity is good, it might help if you
could also attach the table definition - is it just producing a blank
png image? is it in the same projection etc...? How are you accessing
it (ie through WMS, mapscript or standard mapserver output).
I've also copied this back to MapServer list...
cheers
Ben
On 27/04/2011, at 3:26 PM, Graham Walker wrote:
Hi all, fairly new to all this. I was wondering if you could help
me with the following issue. I can't seem to display my postgis
table in mapserver. I can display shapefiles and html templates
fine, but when I try to connect to my postgis table I simply get a
white background (or whatever colour I set it as).
I have managed to display postgis tables before in mapserver, but I
am having no luck in this one and cannot see any differences. Both
the shapefile and postgis table can display in qgis. My map file is
listed below. I have intentionally tried to simplify this down to
the basics so it has no projection details, etc at present. Any
help would be greatly appreciated. Thanks
MAP NAME "test" IMAGETYPE PNG SIZE 400 500 STATUS ON EXTENT
200949 883531 347001 979508 SHAPEPATH "C:\ms4w\Apache\htdocs\test"
UNITS METERS END
WEB IMAGEPATH "c:\ms4w\tmp\ms_tmp\" IMAGEURL "/ms_tmp/" END
#Region Polygons LAYER NAME "North" CONNECTIONTYPE postgis
CONNECTION "user=postgres password=1 dbname=test host=localhost
port=5432" DATA "the_geom from North" TYPE POLYGON STATUS DEFAULT
CLASS STYLE COLOR 1 1 1 OUTLINECOLOR 1 1 1 END END END
_______________________________________________ postgis-users
mailing list postgis-us...@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ mapserver-users
mailing list mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
