[Mapserver-users] PostGIS/Mapserv problem with type MULTIPOLYGON.

[Thierry Lombardot]

Ok,
I found the error. The table I used for this additional data was not 
granted for select for the web user at postgreSQL level... I fixed it 
and everything is working fine. The error had nothing to do with the 
MULTIPOLYGON type. Aren't postgreSQL errors reported to the mapserv CGI 
for an output in all cases?
Sorry for the wasted time...

Thierry

Vinko Vrsalovic wrote:
> On Tue, Sep 09, 2003 at 08:36:48AM -0700, Paul Ramsey wrote:
> 
>>The error in your log means that mapserv is just plain crashing, not 
>>running for you. So you need to figure out why it is crashing first. 
>>Does it run normally for normal shape layers? For a simple point-based 
>>postgis layer? If you delete all the polygons in your layer except one, 
>>does it work? If you run the shp2img program (which is just a 
>>commandline mapserver) do things run? Have you stripped your mapfile 
>>down to just a simple one layer file with nothing special?
>>Basically, you have to diagnose the crash and work back from there. It 
>>is possible you have a polygon in your layer which is capable of 
>>crashing mapserver. Or maybe there is something special wrong in your 
>>environment (an odd mix of library versions) which is causing the crash.
>>
> 
> 
> In my experience, as I said, mapserver crashes when the query doesn't
> return needed columns, as, for instance, in:
> 
> LAYER
> 	CONNECTION ...
> 	CONNECTIONTYPE ...
> 	LABELITEM 'name'
> 	DATA 'the_geom from (select the_geom,oid from table where condition) as foo using unique oid using srid = -1'
> 	# it should be 'the_geom,oid,name from table'
> 	CLASS
> 	 ....
> 	 STYLE
> 	  ...
> 	 END
> 	 LABEL
> 	  ...
> 	 END
> 	END
> END
> 
>