[postgis-devel] [PostGIS] #619: Postgres 9.0 with Postgis 1.5.2 crash on windows on this query

[PostGIS]

#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.