X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DDF0232A6A5 for ; Wed, 20 Oct 2004 15:59:34 +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 67690-09 for ; Wed, 20 Oct 2004 14:59:33 +0000 (GMT) Received: from nat2.zhengmai.net.cn (unknown [202.99.6.61]) by svr1.postgresql.org (Postfix) with SMTP id 2BB77329E77 for ; Wed, 20 Oct 2004 15:59:28 +0100 (BST) Received: (qmail 78750 invoked by uid 89); 20 Oct 2004 15:24:00 -0000 Received: from unknown (HELO ?192.168.1.161?) (laser@qmail.zhengmai.net.cn@221.218.42.154) by 0 with SMTP; 20 Oct 2004 15:24:00 -0000 Message-ID: <41767CDE.5040301@qmail.zhengmai.net.cn> Date: Wed, 20 Oct 2004 22:57:34 +0800 From: Weiping User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: the problem of createlang! References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL, RCVD_IN_RFCI X-Spam-Level: * X-Archive-Number: 200410/144 X-Sequence-Number: 19247 Fang Genjie wrote: > I have installed postgresql (version 7.4.5) on the Redhat linux platform. > > Now I want to create a database with name BBMF and create pl/pgsql > procedure language to the BBMF > > The problem is listed follow: > > > > [postgres@wap1-np postgresql-7.4.5]$ psql -l > > List of databases > > Database | Owner | Encoding > > -----------+----------+----------- > > BBMF | develop | SQL_ASCII > > template0 | postgres | SQL_ASCII > > template1 | postgres | SQL_ASCII > > (3 rows) > > > > [postgres@wap1-np postgresql-7.4.5]$ createlang plpgsql BBMF > > ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: > /usr/local/pgsql/lib/plpgsql.so: undefined symbol: error_context_stack > > createlang: language installation failed > > [postgres@wap1-np postgresql-7.4.5]$ file /usr/local/pgsql/lib/plpgsql.so > > /usr/local/pgsql/lib/plpgsql.so: ELF 32-bit LSB shared object, Intel > 80386, version 1, not stripped > > [postgres@wap1-np postgresql-7.4.5]$ > Most probably is you got two version of postgresql in you system, one from RH, one install by yourself. check the path of your installation and the system one (usually /usr/bin, /usr/lib etc for RH). regards Laser