Zombie index?

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?

i've had a similar problem -- apparently postgres thought the index no
longer existed, but the index file still existed on the HD. i don't know if
this is the correct thing to do or not, but i just went in and deleted the
index file, and things worked fine (for me at least, ymmv) the index file
should be located in $PGDATA/base/{db_name}/{index_name}

I'm getting the following when I do a: make all > & make.log &

Postgres v6.4-BETA2 on a Linux 2.0.34 Intel machine

===========================================================================
gcc -I../../../include -I../../../backend -O2 -Wall -Wmissing-prototypes
-fpic -I../include -I../../../interfaces/libpq -c typename.c -o typename.sho.o
ld -shared -soname libecpg.so.2 -o libecpg.so.2.6.2 ecpglib.sho typename.sho.o
ld: cannot open ecpglib.sho: No such file or directory
make[3]: *** [libecpg.so.2.6.2] Error 1
make[3]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg/lib'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/src/pgsql/src/interfaces'
make: *** [all] Error 2
============================================================================

Did I miss something?

Andy

A few things...

First, this shouldn't be discussed on this mailing list

Second, see First.

this is not a general question, this is a specific one...since it is an
unreleased version of PostgreSQL, the *only* list that it should be
discussed on is pgsql-hackers@postgresql.org...

I also believe that it has been discussed, and corrected, since, on that
same mailing list...

On Thu, 15 Oct 1998, Andy Lewis wrote:

I'm getting the following when I do a: make all > & make.log &

Postgres v6.4-BETA2 on a Linux 2.0.34 Intel machine

===========================================================================
gcc -I../../../include -I../../../backend -O2 -Wall -Wmissing-prototypes
-fpic -I../include -I../../../interfaces/libpq -c typename.c -o typename.sho.o
ld -shared -soname libecpg.so.2 -o libecpg.so.2.6.2 ecpglib.sho typename.sho.o
ld: cannot open ecpglib.sho: No such file or directory
make[3]: *** [libecpg.so.2.6.2] Error 1
make[3]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg/lib'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/src/pgsql/src/interfaces'
make: *** [all] Error 2
============================================================================

Did I miss something?

Andy

Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org
scrappy@{postgresql|isc}.org ICQ#7615664

Hello Andy,

gioved�, 15 ottobre 98, you wrote:

AL> I'm getting the following when I do a: make all > & make.log &

AL> Postgres v6.4-BETA2 on a Linux 2.0.34 Intel machine

AL> ===========================================================================
AL> gcc -I../../../include -I../../../backend -O2 -Wall -Wmissing-prototypes
AL> -fpic -I../include -I../../../interfaces/libpq -c typename.c -o typename.sho.o
AL> ld -shared -soname libecpg.so.2 -o libecpg.so.2.6.2 ecpglib.sho typename.sho.o
AL> ld: cannot open ecpglib.sho: No such file or directory
AL> make[3]: *** [libecpg.so.2.6.2] Error 1
AL> make[3]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg/lib'
AL> make[2]: *** [all] Error 2
AL> make[2]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg'
AL> make[1]: *** [all] Error 2
AL> make[1]: Leaving directory `/usr/src/pgsql/src/interfaces'
AL> make: *** [all] Error 2
AL> ============================================================================

AL> Did I miss something?

AL> Andy

edit file: /home/postgres/pgsql/src/interfaces/ecpg/lib/Makefile
change ecpglib.sho to ecpglib.sho.o
and then re-compile.

Jose'