Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199603052109.NAA23314@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Message-Id: <199603052106.WAA09702@zen.gams.co.at>
To: avi@baan.nl
Cc: postgres@postgres.Berkeley.EDU
In-Reply-To: Your message of "Tue, 05 Mar 1996 14:33:15 +0100."
             <9603051333.AA59386@green.baan.nl> 
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Tue, 05 Mar 1996 22:06:36 +0100
From: "V.Grabner" <zen@bononunu.gams.co.at>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Tue, 05 Mar 96 13:09:51 -0800
Resent-XMts: smtp

> To all,
> 
> I've succeeded to compile the complete postgres v4.2 for my HP9000 425t
> under HPUX 9.10 but I have some problems during the initdb phase:
> 
> I'm getting the following messages:
> fmgr_info: function 0: cache lookup failed.
> 
> 12 like these in a row. I've tracked down the guilty lines responsable
> for these errors:
> they occur in the 'declare index on ....' at the end of the 
> local1_template1.bki (or something) file.
> 
> It appears that the SearchSysCacheTuple() function fails.
> 
> Is there still a postgres expert around who can tell me where I should
> look? 

We had the same problem when using hash indices. Hash indices
alsways crashed the database when creating an index or inserting 
> 50 rows into the table.

Do not use them, use btree indices instead.

I tried to trace the problem but I did not find it. I found
out it always happend during the split of an hash page but I
never found out why. Without documentation I was lost.

--zen
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 Vinzenz Grabner                             Voice   : + 43 1 817 62 30-15
 G.A.M.S. GmbH.                              Fax     : + 43 1 817 62 30-17
 Schoenbrunnerstr. 179/II/4.St.
 A-1120 Vienna/Austria/Europe                e-mail  : zen@gams.co.at
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/