Win PostgreSQL/Postgis Mapserver layer problem

[Mladen Kotarac]

With the availability of native Windows installers for PostgreSQL 8.0:
http://pgfoundry.org/projects/pginstaller

and Postgis:
http://dcmms.sourceforge.net/postgis_installer.php

(for those who missed them)

it is much easier to deploy Windows Postgis installations.

While Postgis seems to be running fine when using PgAdmin III (only with the
development version 1.10 included in the PostgreSQL installation!!!) and all
the examples from workshop Intro to PostGIS (Paul Ramsey & Chris Hodgson at
OS Gis 2004) can be tried and rerun, I am not able to set up a Mapserver
(MapServer version 4.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=PDF OUTPUT=SWF SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT INPUT=POSTGIS
INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE) layer based on Postgis data.

The PostgreSQL server simply dies without explanation.
The same query from below ("select the_geom from not1") executes without
problem when run from PgAdmin III and returns a geometry column.

An excerpt of the map file follows:
---------------------------------
LAYER
 NAME bla
 TYPE point
 CONNECTIONTYPE postgis
 CONNECTION "host=192.160.17.32 dbname=dcmms user=postgres"
 DATA "the_geom from not1"
 STATUS ON

   CLASS
      #  NAME Locality
        TEMPLATE 'lutka'
 COLOR 1 1 1
        OUTLINECOLOR 1 255 1
        SYMBOL 1
 SIZE 4
   END  # CLASS
END# LAYER
---------------------------------

Any help would be appreciated.

BR

Mladen



P.S. MySQL spatial support is at the stage of 4.1.3 beta, 4.1 branch
becoming production MySQL in a couple of weeks time. What are the plans for
"true" spatial MySQL support in Mapserver?