Tom, I'm puzzled!
I tried postgresql 7.3 and 7.3.1 and they both fail regressin when creating plpgsql language. However, when installed, createlang plpgsql template1 work like a charm. Could it be because the machine is slow (and disks too!) Regards, On Thu, 26 Dec 2002, Tom Lane wrote: > Date: Thu, 26 Dec 2002 13:44:51 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: [HACKERS] Problems with 7.3.1 > > Olivier PRENANT <[EMAIL PROTECTED]> writes: > > Compile works ok however make check fails wile creating pl/pgsql with : > > WARNING: bt_getroot[pg_proc_proname_nsp_index]: fixing root page > > ERROR: bt_fixroot: not valid old root page. > > Wow. Is the behavior reproducible? How about if you go ahead and > install, and do a plain "make installcheck" (or even just try a manual > createlang in a fresh database)? > > That code thinks it is dealing with a concurrent index root page split, > but there couldn't be any concurrent operations happening during the > create-plpgsql step of a regression test run. Can you step through > _bt_getroot() (it's in src/backend/access/nbtree/nbtpage.c) and figure > out exactly how it's getting confused? > > If the behavior is reproducible I'm inclined to suspect a compiler bug; > it's hard to see how _bt_getroot could get so confused otherwise. > > regards, tom lane > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html