X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E9B3C32A116 for ; Thu, 30 Sep 2004 16:39:20 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42501-01 for ; Thu, 30 Sep 2004 15:39:19 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 6283532A0AA for ; Thu, 30 Sep 2004 16:39:19 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i8UFdG5c043045 for ; Thu, 30 Sep 2004 15:39:18 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i8UFYZql041386 for pgsql-admin@postgresql.org; Thu, 30 Sep 2004 15:34:35 GMT From: stig erikson X-Newsgroups: comp.databases.postgresql.admin Subject: Re: fedora core 2 postgresql regression tests fail Date: Thu, 30 Sep 2004 17:32:59 +0200 Organization: Hub.Org Networking Services Lines: 100 Message-ID: References: <415B866D.4090203@ccis.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8a4) Gecko/20040927 X-Accept-Language: en-us, en, sv, nn, nb, no, pl In-Reply-To: <415B866D.4090203@ccis.com> X-Enigmail-Version: 0.86.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/9 X-Sequence-Number: 15003 John McBride wrote: > Hello, > > I have been playing with postgresql at home, working through a book on > general database installation and use. Mostly it is an oracle book, but > much of the book is easily translated to Postgres. This is on a fedora > core 2 linux box, kept fully yum updated. > > Here are the packages installed via yum: > > $ rpm -qa | grep postgres > postgresql-libs-7.4.2-1 > postgresql-server-7.4.2-1 > postgresql-test-7.4.2-1 > postgresql-7.4.2-1 > postgresql-devel-7.4.2-1 > > Then I enable plpgsql: > > $ droplang plpgsql template1 > $ createlang plpgsql template1 > $ createlang -l template1 > Procedural Languages > Name | Trusted? > ---------+---------- > plpgsql | yes > > As user postgres I try and run the tests: > > $ pwd > /usr/lib/pgsql/test/regress > $ time ./pg_regress.sh --schedule=parallel_schedule > .... > ==================================================== > 6 of 93 tests failed, 1 of these failures ignored. > ==================================================== > .... > > $ grep -i FAIL ./regression.out > test create_function_1 ... FAILED > triggers ... FAILED > plpgsql ... failed (ignored) > copy2 ... FAILED > rangefuncs ... FAILED > test stats ... FAILED > > Here are some results from the diffs: > > $ grep ERROR regression.diffs > ERROR: could not access file "nosuchfile": No such file or directory > ! ERROR: Can't find function nosuchsymbol in file > /usr/lib/pgsql/test/regress/regress.so > ERROR: there is no built-in function named "nosuch" > ERROR: could not access file "nosuchfile": No such file or directory > ! ERROR: could not find function "nosuchsymbol" in file > "/usr/lib/pgsql/test/regress/regress.so" > ERROR: there is no built-in function named "nosuch" > + ERROR: language "plpgsql" does not exist > + ERROR: function trigger_func() does not exist > + ERROR: function trigger_func() does not exist > + ERROR: function trigger_func() does not exist > + ERROR: function trigger_func() does not exist > + ERROR: language "plpgsql" does not exist > .... > > $ grep plpgsql regression.diffs | more > + ERROR: language "plpgsql" does not exist > *** ./expected/plpgsql.out Wed Sep 24 23:58:06 2003 > --- ./results/plpgsql.out Mon Sep 27 21:11:32 2004 > ' language 'plpgsql'; > + ERROR: language "plpgsql" does not exist > .... > > $ grep HINT regression.diffs > + HINT: You need to use "createlang" to load the language into the > database. > .... > > So I guess I am confused. I thought I added the required language > (plpgsql) properly. Sorry if this is something obvious, I have googled > several times and have not found much help for this. > > Perhaps I should be building from source or using the RedHat "rhdb" iso? > > Thanks for any hints, > John > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > might or might not help for your test, there is a 7.4.5 version for fedora core 2. you can find it on any of the mirrors, for example: ftp://ftp7.de.postgresql.org/pub/ftp.postgresql.org/binary/v7.4.5/rpms/fedora/fedora-core-2