agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: V.Grabner <zen@bononunu.gams.co.at>
To: avi@baan.nl
Cc: postgres@postgres.Berkeley.EDU
Date: Tue, 05 Mar 1996 22:06:36 +0100
Message-ID: <199603052106.WAA09702@zen.gams.co.at> (raw)
In-Reply-To: <9603051333.AA59386@green.baan.nl>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: zen@bononunu.gams.co.at, avi@baan.nl
  Subject: Re: 
  In-Reply-To: <199603052106.WAA09702@zen.gams.co.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox