Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA03377; Wed, 18 Nov 92 10:23:00 -0800
Message-Id: <9211181823.AA03377@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: Is this a bug?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Wed, 18 Nov 92 08:56:33 EST.
             <9211181356.AA02213@cmsun.cmf.nrl.navy.mil> 
Date: Wed, 18 Nov 92 10:16:47 PST

In message <9211181356.AA02213@cmsun.cmf.nrl.navy.mil> you write:

> create usgs_cities (name = text, state = text, elev = float4, pop = float4, l
  +oc = 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...

loc is of type point, and you're trying to index it as if it were of
type float8.  this won't work.  the naming convention for operator classes
is that <type>_ops are used to index values of type <type>.

there's no operator class that will index point values in btrees in the
distributed system.
					mike