[postgis-users] GIST index create failure

[Markus Schaber]

Hi, Dave,

Dave Stone wrote:
> I'm trying to create a spatial index on a simple table with a geometry
> column. I've tried doing this via the PostgreSQL command line and using
> phppgAdmin. So for table 'loccoords' with column 'geom' of type
> 'geometry', the SQL is:
> 
> create index loccoords_gistix on loccoords using gist(geom
> gist_geometry_ops);
> 
> and the result is:
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

Can you run "SELECT count(*),isvalid(geom) FROM loccoords GROUP BY
isvalid(geom)"?

> Has anyone met this before?

When we had similar problems, it was due to version mismatches between
libraries, fatal bugs in PostGIS and hardware defects / data corruption.

> I have successfully created a GIST index
> before (on an earlier version of the same table, with fewer than the
> present 357 rows).

We've GIST indices on tables with millions of rows, so that should not
be the problem.


HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org