Re: Postgres 9.0 crash on win7

  Hi,

I do some others tests.

I f I remove all the call to postgis elements the PG0 don't crash.

If I set
autovacuum = off

and run this script (it is also in attach).

The PG9 don't crash istantly, but if after run the script I do
VACUUM;
ANALYZE;
the PG9 crash meanwhile execute the analyze.

It seem to be a problem of Postgis, but I have some doubt because
this same script work well on PG8.4.4 with postgis 1.5.2 (compiled for 
postgres 8.4.4)
meanwhile on PG9 with postgis 1.5.2 (compiled for postgres 9.0) it crash 
PG9.

-----
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;
-----

Regards,

Andrea Peri.