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.