<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=609051422-02032003><FONT face=Arial size=2>Hi
all,</FONT></SPAN></DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial size=2>I'm have trouble
when I create a GIST index on a geometry field in a table. I get the
following error:</FONT></SPAN></DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial size=2>create index
featurethe_geom on feature using GIST(the_geom);</FONT></SPAN></DIV><SPAN
class=609051422-02032003>
<DIV><BR><FONT face=Arial size=2>server closed the connection
unexpectedly<BR> This probably means
the server terminated abnormally<BR>
before or while processing the request.<BR>The connection to the server was
lost. Attempting reset: DEBUG: server process<BR>(pid 1430) was terminated
by signal 11<BR>DEBUG: terminating any other active server
processes<BR>DEBUG: all server processes terminated; reinitializing shared
memory and semaph<BR>ores<BR>DEBUG: database system was interrupted at
2003-03-03 08:33:07 CST<BR>DEBUG: checkpoint record is at
0/63D9CE4<BR>DEBUG: redo record is at 0/63D9CE4; undo record is at 0/0;
shutdown TRUE<BR>DEBUG: next transaction id: 17744; next oid:
258077<BR>DEBUG: database system was not properly shut down; automatic
recovery in progre<BR>ss<BR>FATAL 1: The database system is starting
up<BR>Failed.<BR>!# DEBUG: redo starts at 0/63D9D24<BR>DEBUG:
ReadRecord: invalid magic number 0000 in log file 0, segment 6, offset
4<BR>104192<BR>DEBUG: redo done at 0/63E60C0<BR>DEBUG: database
system is ready<BR>!#</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial size=2>I checked the list
and read about a bug at <A
href="http://postgis.refractions.net/pipermail/postgis-users/2002-May/000978.html">http://postgis.refractions.net/pipermail/postgis-users/2002-May/000978.html</A> in
version 7.2.1 which sounds a little like the problem I'm having. I'm
running 7.2.2 on R.H 8, so does anyone know if this is fixed in this release? If
I run the same create index statement on a 7.2.3 winxp/cygwin install of
postgres it works fine.</FONT></SPAN></DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial
size=2>Cheers,</FONT></SPAN></DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609051422-02032003><FONT face=Arial size=2>Benjamin
Wragg</FONT></SPAN></SPAN></DIV></BODY></HTML>