[postgis-users] Postgis -> Mapserver white background

[Graham Walker]

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