Zombie index?

From: Christophe Pettus <pettus(at)postdirect(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: Zombie index?
Date: 1998-10-15 20:59:26
Message-ID: 3.0.3.32.19981015135926.0094ebe0@exchange.postdirect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm having a problem with an index on a Postgres database.

I created an index as follows:

create index table1_column1 on table1 using hash (column1);

(column1 is a varchar(70))

I discovered that I couldn't actually use this index for anything; any
query which uses column1 in the where clause comes up with:

ERROR: hash table out of memory. Use -B parameter to increase buffers.

I then dropped it:

drop index table1_column1;

Now, I can't create an index with that name:

ERROR: cannot create table1_column1

In fact, the index doesn't seem to be *really* gone. Any query which
uses column1 still gives that error message. Whuzzup?

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Hoffmann 1998-10-15 21:40:52 Re: [GENERAL] Zombie index?
Previous Message Jackson, DeJuan 1998-10-15 20:46:45 RE: [GENERAL] Easiest and shortest way?