[postgis-devel] [PostGIS] #619: Postgres 9.0 with Postgis 1.5.2 crash on windows on this query
PostGIS
trac at osgeo.org
Mon Oct 4 12:43:00 PDT 2010
#619: Postgres 9.0 with Postgis 1.5.2 crash on windows on this query
-----------------------+----------------------------------------------------
Reporter: aperi2007 | Owner: pramsey
Type: defect | Status: new
Priority: high | Milestone: PostGIS 1.5.3
Component: postgis | Version: 1.5.X
Keywords: |
-----------------------+----------------------------------------------------
On Postres 9.0 with postgis 1.5.2 and Windows 7 (32bit/64bit)
setting
autovacuum = off
and executing this query:
----
SELECT DropGeometryColumn('public','poslist','geom');
DROP TABLE IF EXISTS poslist;
SELECT DropGeometryColumn('public','suolo','geom');
DROP TABLE IF EXISTS suolo;
SELECT DropGeometryColumn('public','linee_elementari','geom');
DROP TABLE IF EXISTS linee_elementari;
CREATE TABLE SUOLO (CODPOLIGONO VARCHAR(35) PRIMARY KEY, CODCLASSE
VARCHAR(35), CODORIGINESUOLO VARCHAR(35), TAGNO INTEGER );
SELECT AddGeometryColumn( 'public','suolo', 'geom',3003, 'POLYGON', 2 );
alter table suolo add column oid serial not null;
CREATE TABLE POSLIST (ID VARCHAR(35) PRIMARY KEY, IDLINESTRING
VARCHAR(35), POSLIST VARCHAR(200000), LUNG_POSLIST INTEGER, NUM_VERTEX
INTEGER , DIMENSION VARCHAR(1) );
SELECT AddGeometryColumn( 'public','poslist', 'geom',3003, 'LINESTRING', 2
);
alter table poslist add column oid serial not null;
CREATE TABLE LINEE_ELEMENTARI (CODLINEA VARCHAR(35) PRIMARY KEY, CODCTR
VARCHAR(35), CODVISIBILITA VARCHAR(35), CODBREAKLINE VARCHAR(35),
CODCLASSE VARCHAR(35), CODLATOVESTIZIONE VARCHAR(35), CODORIGINELINEA
VARCHAR(35), CODMODIFICA VARCHAR(35), POSLIST VARCHAR(200000),
LUNG_POSLIST INTEGER, NUM_VERTEX INTEGER, IDEDGE VARCHAR(35), SRSNAME
VARCHAR(35), DIMENSION VARCHAR(1), COORD_N1 VARCHAR(50), COORD_N2
VARCHAR(50) );
SELECT AddGeometryColumn( 'public','linee_elementari', 'geom',3003,
'LINESTRING', 2 );
alter table linee_elementari add column oid serial not null;
----
If after the execution of the query I run this two commands:
vacuum;
analyze;
the PG9 crash.
The same query work without any problems on PG8.4.4 + postgis 1.5.2
(bug reported even to pgsql-bugs ML)
http://archives.postgresql.org/pgsql-bugs/2010-10/msg00031.php
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/619>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list