[postgis-users] MapServer and PostGIS 1 RC1 and RC2
Mark Cave-Ayland
m.cave-ayland at webbased.co.uk
Thu Jan 27 03:54:43 PST 2005
Hi Duster,
Looks OK from here too (Win32, PostGIS 1.0RC2).....
Welcome to psql 8.0.0, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
Warning: Console code page (850) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page "Notes for Windows users" for details.
postgis100rc2=# create table test_pnt (id serial);
NOTICE: CREATE TABLE will create implicit sequence "test_pnt_id_seq" for
serial
column "test_pnt.id"
CREATE TABLE
postgis100rc2=# select
addgeometrycolumn('public','test_pnt','wkb_geometry',-1,'
POINT',2);
addgeometrycolumn
--------------------------------------------------------
public.test_pnt.wkb_geometry SRID:-1 TYPE:POINT DIMS:2
geometry_column fixed:0
(1 row)
postgis100rc2=# insert into test_pnt (wkb_geometry) values
(Geometryfromtext('POINT(610000 230000)',-1));
INSERT 29373 1
postgis100rc2=# SELECT
asbinary(force_collection(force_2d(wkb_geometry)),'NDR')
FROM test_pnt;
asbinary
----------------------------------------------------------------------------
----
---------------------------------
\001\007\000\000\000\001\000\000\000\001\001\000\000\000\000\000\000\000\240
\23
5"A\000\000\000\000\200\023\014A
(1 row)
postgis100rc2=# select postgis_full_version();
postgis_full_version
----------------------------------------------------------------------------
----
-------------------------
POSTGIS="1.0.0RC2" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
DBPROC
="0.1.0" RELPROC="0.1.0"
(1 row)
postgis100rc2=#
Have you tried creating a new database cluster with initdb? Perhaps the
database cluster itself has become corrupted. Strk, do you think it would be
worth including the output of "uname" in postgis_full_version() so it is
possible to distinguish between different platform builds?
Kind regards,
Mark.
------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT
T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On
> Behalf Of strk at refractions.net
> Sent: 27 January 2005 11:18
> To: Düster Horst
> Cc: 'postgis-users at postgis.refractions.net'
> Subject: Re: [postgis-users] MapServer and PostGIS 1 RC1 and RC2
>
>
> I don't get the same result:
>
> [lo:asbinary_crash]$ cat test.sql
> select postgis_full_version();
> create table test_pnt (id serial);
> select
> addgeometrycolumn('public','test_pnt','wkb_geometry',-1,'POINT',2);
> insert into test_pnt (wkb_geometry) values
> (Geometryfromtext('POINT(610000 230000)',-1));
> SELECT
> asbinary(force_collection(force_2d(wkb_geometry)),'NDR') FROM
> test_pnt;
> SELECT summary(wkb_geometry) from test_pnt;
>
>
> [lo:asbinary_crash]$ psql -etf test.sql test
> select postgis_full_version();
> POSTGIS="1.0.0RC2" GEOS="2.1.1" PROJ="Rel. 4.4.8, 3 May
> 2004" USE_STATS DBPROC="0.1.0" RELPROC="0.1.0"
>
> create table test_pnt (id serial);
> psql:test.sql:2: NOTICE: CREATE TABLE will create implicit
> sequence "test_pnt_id_seq" for serial column "test_pnt.id"
> CREATE TABLE
> select
> addgeometrycolumn('public','test_pnt','wkb_geometry',-1,'POINT',2);
> public.test_pnt.wkb_geometry SRID:-1 TYPE:POINT DIMS:2
> geometry_column fixed:0
>
> insert into test_pnt (wkb_geometry) values
> (Geometryfromtext('POINT(610000 230000)',-1));
> INSERT 11512442 1
> SELECT
> asbinary(force_collection(force_2d(wkb_geometry)),'NDR') FROM
> test_pnt;
>
> \001\007\000\000\000\001\000\000\000\001\001\000\000\000\000\0
> 00\000\000\240\235"A\000\000\000\000\200\023\014A
>
> SELECT summary(wkb_geometry) from test_pnt;
>
> Point[]
>
> What OS ? What postgresql version ?
> Any warning at build time ?
>
> --strk;
>
> On Thu, Jan 27, 2005 at 12:02:18PM +0100, Düster Horst wrote:
> > > You mean 'geometry', right ?
> >
> > Of course I meant type of geometry.
> >
> >
> > > Also, did you dump/reload or manually upgrade postgis ?
> > I created a new blank PostgreSQL-8.0.0 DB with:
> > # createdb test
> > # createlang plpgsql test
> > # psql -d test -f lwpostgis.sql
> >
> >
> > > Can you reproduce the bug on a single POINT geometry ?
> > Here the steps that produces a single POINT geometry and
> leads to the
> > server
> > crash:
> >
> > # create table test_pnt (id serial);
> > CREATE TABLE
> >
> > # select
> addgeometrycolumn('public','test_pnt','wkb_geometry',-1,'POINT',2);
> > addgeometrycolumn
> >
> ----------------------------------------------------------------------
> > ------
> > -----
> > public.test_pnt.wkb_geometry SRID:-1 TYPE:POINT DIMS:2
> > geometry_column fixed:0
> > (1 row)
> >
> > # insert into test_pnt (wkb_geometry) values
> > (Geometryfromtext('POINT(610000 230000)',-1)); INSERT 16691569 1
> >
> > # SELECT
> asbinary(force_collection(force_2d(wkb_geometry)),'NDR') FROM
> > test_pnt; server closed the connection unexpectedly
> > This probably means the server terminated abnormally
> > before or while processing the request.
> >
> >
> > > If you can show me summary(that_point)
> >
> > # select summary(wkb_geometry) from test_pnt;
> > summary
> > -----------
> >
> > Point[]
> >
> > (1 row)
> >
> >
> >
> > 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:44
> > 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: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
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
More information about the postgis-users
mailing list