Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06546; Wed, 16 Dec 92 06:40:27 -0800
Message-Id: <9212161440.AA06546@postgres.Berkeley.EDU>
From: Herb HASLER <herb@iiasa.ac.at>
Subject: Problem with indexes.
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.Berkeley.EDU
Date: Wed, 16 Dec 1992 15:42:36 +0100 (MET)
X-Mailer: ELM [version 2.4 PL8]
Content-Type: text
Content-Length: 672       


I have (I think) a simple problem. 

I have created a class PERSON which contains many 'text' attributes,
among them lname, fname, address, etc.   Then I added a number of instances.
Now I tried to create a btree index on one of the attributes with:

* define index pindex on PERSON using btree (lname text_ops)

When I go to do a query such as:

* retreive (PERSON.all) where PERSON.lname = "Smith"

It returns the message:
WARN:Dec 16 15:35:24:getattnvals: no attribute tuple 28660 1


Without the index it works fine.  The <, >, != operators work fine. 
Am I doing something stupid or incorrectly? 


Thanks for any guidance you can give,
Herb Hasler

herb@iias.ac.at