Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA02341; Wed, 18 Nov 92 05:55:53 -0800
Date: Wed, 18 Nov 92 05:55:53 -0800
Message-Id: <9211181355.AA02341@postgres.Berkeley.EDU>
From: rodrigo@cmf.nrl.navy.mil
Subject: Is this a bug?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Cc: bug-postgres@postgres.berkeley.edu



Hi all, 

I have been running postgres 4.0.1 for a couple of weeks 
without any problems until now. I loaded a mediumm size file 
of 132,000 records here is the create statement

create usgs_cities (name = text, state = text, elev = float4, pop = float4, loc = point)\g

then I loaded using a copy command 

copy usgs_cities from "/h/rod/postgres/usgs_cities.data"\g

So far no problems. Now I tried to build an index on the point 
by doing this 

define index usgs_cities_ind on usgs_cities using btree (loc float8_ops)\g

Well this one ran for 10 minutes and the exited with the message 

Error: No response from the backend, exiting...


I tried also to define the index first and then copy, same thing 
happened after 20 minutes. 

I have a SPARC 330 running SUNOS 4.1.1. 

Is this a bug or am I doing something wrong here?

Thanks for your help.

rodrigo@cmf.nrl.navy.mil