[postgis-users] MapServer and PostGIS 1 RC1 and RC2

[strk at refractions.net]

On Thu, Jan 27, 2005 at 09:03:18AM +0100, Düster Horst wrote:
> Now my third attempt to get an answer of my posted question.
> Since a time I'm playing with MapServer 4.4.1 and PostGIS 1RC1 and RC2 since
> today with semi
> success. I'm able to create maps with polygon and line layers from PostGIS,
> but PostGIS/Postgres crashes with the error message (see below) when I
> use a point layer. This crash appears exclusively with all my point layers
> which work fine with MS 4.4.1 and Postgis 0.8. Do there exist any
> restrictions of using PostGIS 1 with MapServer 4.4.1?? 
> 
> I would be appreciate about any hint.
> 
> With best regards
> 
> Horst
> 
> Mapfile snippet:
> 
> ...
> LAYER
>   CONNECTIONTYPE POSTGIS
>   CONNECTION 'dbname=xx host=xx user=xx port=5432'
>   DATA "wkb_geometry from asit2 USING UNIQUE ogc_fid USING SRID=-1"
>   TYPE POINT
> ...

What type is  wkb_geometry ?

Did you try manually issuing the query ? 
  # SELECT asbinary(force_collection(force_2d(wkb_geometry)),'NDR')
    FROM avt_asit_unfall;

--strk;

> 
> 
> 
> Error message:
> > msDrawMap(): Image handling error. Failed to draw layer named 'asit2'. 
> > msPOSTGISLayerWhichShapes(): Query error. Error executing POSTGIS SQL
> > statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT
> >
> ANZ_TOT::text,asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),ogc_f
> > id::text from avt_asit_unfall WHERE wkb_geometry &&
> setSRID('BOX3D(588837.5
> > 213700,648462.5 261400)'::BOX3D, -1 ) -server closed the connection
> > unexpectedly This probably means the server terminated abnormally before
> or
> > while processing the request. Error with POSTGIS data variable. You
> > specified ''.
> > Standard ways of specifiying are : 
> > (1) 'geometry_column from geometry_table' 
> > (2) 'geometry_column from (<sub query>) as foo using unique <column name>
> > using SRID=<srid#>' 
> >
> > Make sure you put in the 'using unique <column name>' and 'using SRID=#'
> > clauses in. 
> >
> > For more help, please see http://postgis.refractions.net/documentation.php
> 
> >
> > Mappostgis.c - version of Jan 23/2004. 
> 
> 
> 
> ---------------------------------
>  
> Dr. Horst Düster 
> GIS-Koordinator /Amtschef Stv.
> 
> Kanton Solothurn 
> Amt für Geoinformation
> Abteilung SO!GIS Koordination
> Werkhofstr. 65
> CH-4509 Solothurn 
> 
> Tel.: ++41 (0)32 627 25 32 
> Fax: ++41 (0)32 627 22 14
> 
> horst.duester at bd.so.ch 
> www.sogis.so.ch
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users