It works! I can run perftest without having to keep an unaccessible index.

I do have some problems with heap_delete though:

sql error Error: ERROR:  heap_delete: (am)invalid tid
 line 120.
sql error Error: ERROR:  heap_delete: (am)invalid tid
 line 120.
sql error Error: ERROR:  heap_delete: (am)invalid tid
 line 120.

What does this mean? BTW line 120 is exec sql drop table perftest1;

Interestingly enough I can drop both tables from psql afterwards.

Michael
-- 
Michael Meskes			meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

Wed, 9 Sep 1998 08:52:50 +0200
Michael Meskes <meskes@online-club.de>
inx problem fixe