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

[strk at refractions.net]

On Thu, Jan 27, 2005 at 09:39:03AM +0100, Düster Horst wrote:
> strk
> 
> > What type is  wkb_geometry ?
> 
> wkb_geometry is type of POINT

You mean 'geometry', right ?

> 
> > Did you try manually issuing the query ? 
> >   # SELECT asbinary(force_collection(force_2d(wkb_geometry)),'NDR')
> >    FROM avt_asit_unfall;
> 
> PostgreSQL responsed with
> 
> server closed the connection unexpectedly
> 	This probably means the server terminated abnormally
> 	before or while processing the request.

Can you reproduce the bug on a single POINT geometry ?
If you can show me summary(that_point).
Also, did you dump/reload or manually upgrade postgis ?

--strk;

> 
> 
> 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
> 
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: strk at refractions.net [mailto:strk at refractions.net]
> Gesendet am: Donnerstag, 27. Januar 2005 09:29
> An: Düster Horst
> Cc: 'postgis-users at postgis.refractions.net'
> Betreff: Re: [postgis-users] MapServer and PostGIS 1 RC1 and RC2
> 
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users