Thread

1. Re: [GENERAL] Zombie index?

   Jeff Hoffmann <jeff@remapcorp.com> — 1998-10-15T21:40:52Z

   >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}
   
   
   
   
   

2. v6.4-BETA2 Compile error

   Andy <alewis@mpsi.net> — 1998-10-15T21:58:53Z

   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
   
   
   

3. Re: [GENERAL] v6.4-BETA2 Compile error

   Marc G. Fournier <scrappy@hub.org> — 1998-10-16T12:27:13Z

   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
   
   
   

4. Re: [GENERAL] v6.4-BETA2 Compile error

   jose' soares <sferac@bo.nettuno.it> — 1998-10-16T12:53:19Z

   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'